e.Spreadsheet Designer

e.Spreadsheet Designer is for report developers and Excel experts who rely heavily on Excel to perform their jobs and want to automatically populate files with new data and modify them to accommodate different audiences. Java developers also use e.Spreadsheet Designer to design spreadsheet templates that are leveraged with the e.Spreadsheet Engine and API product as part of an application. e.Spreadsheet reports can be generated and viewed within e.Spreadsheet Designer itself or by the e.Spreadsheet Engine and API , Deployment Kit and iServer Express products.

excel tips

Handling Excel Errors
VBA: UDF to perform a 3-parameter Vlookup
automate excel 

Tips by Category

Tips By Excel Version

Recommended Tips

Most Viewed Tips Use Windows PowerShell to Automate Microsoft Excel

#This cmdlet picks the servers from workstations.txt one by one, and collects IP details of each server and pushes them #into excel sheet 

wmi-excel

WMI simplifies system information retrieval
some examples of WMI procedures adapted in Excel
Retrieving hardware information with WMI

Connecting to WMI Objects

project - exchaneg automation

• create a 15 element samacctIndex array and populate with 0
  
• remove spaces from last name - use regx
  
• combine 1st letter of frist name with revised last name -samacctMain
  
• search 4 all samacctMain
• 4 each samacctMain use regex 2 strip samacctIndex
• put samacctIndex in samacctIndex(samacctIndex) element replacing 0
• search 4 first 0 in samacctIndexarray the element # will become the samacctIndex
• combine samacctMain+samacctIndex = samacctName
• destroy & recreate a 15 element samacctIndex array and populate with 0

admin ou & groups

• get all users with admin loc codes
• ou they're in
• groups they're in
• other qualifiers i.e department responsibility
• look 4 coreolation

HOW TO: Reconnect a mailbox to another user

VBScript to create a large number of mailbox-enabled user accounts

sorting excel data via VBA
sort method doc
Using VBA to Sort Data on Multiple Sheets
Sorting Cells using VBA
subroutine which will sort the active worksheet by first column, then remove any duplicates
re-sorts a named range when data is added

replace a user acct ctrl-F

Sorting a Range using VBA - Excel Help Forum

The Recipient Update Service and Linked Value Replication

Select a Product Advanced SearchHow to work with the Exchange Recipient Update Service

How to Manually Update the Recipient Update Service via script

Creating Exchange Users with Excel (Part 1)

Creating Exchange Users with Excel (Part 2)

exchange Management & Administration Articles

The SelfADSI Tutorial introduces administrators to the scripting in Active Directory environments and other LDAP directory systems. The aim is to understand and being able to develop directory scripts without having specific previous knowledge in ADS or LDAP. Preferred scripting language is Visual Basic Script (VBScript). ADS scripting / LDAP scripting is easy - learn it with SelfADSI.

The minimum attributes needed for RUS are mailNickname (Exchange Alias) and msExchHomeServerName

In this section of the SelfADSI Scripting tutorial the Exchange 2000/Exchange 2003 attributes of an Active Directory Services object will be described. These AD attributes and the additional tabs in the admin utility are only visible if Exchange has been installed in the Active Directory forest and if the according management tools exist on your machine - and if the regarding object is mail enabled.

http://www.microsoft.com/technet/scriptcenter/scripts/message/default.mspx?mfr=true

Alphabetical list of AD attributes

SelfADSI tutorial according "Creating mail enabled users".

A User Comes and a User Goes

http://www.petri.co.il/creating_exchange_users_with_excel.htm



http://msdn.microsoft.com/en-us/library/aa221612(office.11).aspx



http://msdn.microsoft.com/en-us/library/aa221357(office.11).aspx



http://www.ozgrid.com/



http://digiassn.blogspot.com/2006/01/multiple-row-selection-in-excel-vba.html

getting married

http://forums.msexchange.org/m_1800465423/tm.htm

http://forums.msexchange.org/m_180041600/tm.htm

http://forums.msexchange.org/m_1800412283/tm.htm

http://forums.msexchange.org/m_10075700/tm.htm

what is your recipient policy.

pivot table 2

PivotTable reports 101 - Excel - Microsoft Office Online
Microsoft Excel Pivot Tables Tips and Tricks from Excel Tip .com - Microsoft Excel Tips - TMPL_VAR NAME=vtitle
Excel 2003 - Pivot Tables - Movies
Pivot Tables Tutorial
Microsoft Excel Pivot Tables
Pivot Tables. Excel Pivot Table Example Downloads & Tutorials
Mathtools.net : Excel/Pivot tables

[PDF]
Pivot Table Introduction
[PDF]
Data Analysis with Microsoft Excel 2003
Pivot Tables Pivot Table Sorting - Excel Help & VBA Help
Filter selection in Graph printout - MrExcel Message Board

pivot tables

Customize a pivot table in Microsoft Office Excel 2007

Pivot TablesTutorialhttp://lacher.com/toc/tutpiv.htm
Learn to Use Pivot Tables Effectively
http://spreadsheets.about.com/b/a/117127.htm
Excel Pivot Tables
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
Demo: Analyze sales with a PivotTable report

PivotTable I: Get started with PivotTable reports in Excel 2007
Help and How-to > Training > Excel 2007
Rating: (10739 votes)

Design the layout and format of a PivotTable report
Excel > Excel 2007 Help and How-to > PivotTable reports and PivotChart reports > Layout and format

Custom calculations for PivotTable data fields
Excel
> Excel 2007 Help and How-to
> PivotTable reports and PivotChart
office online pivot table search results



PivotTable I: Get started with PivotTable reports in Excel 2007
Length: 30 min
Rating: (10739 votes)


PivotTable II: Filter PivotTable report data in Excel 2007
Length: 30 min

PivotTable III: Calculate data in PivotTable reports in Excel 2007



Charts I: How to create a chart in Excel 2007

Display or hide items or levels in a PivotTable report
Excel
> Excel 2007 Help and How-to
> PivotTable reports and PivotChart reports
> Layout and format

excel functions

vLookUp
Excel VLookup Function
Excel -- Worksheet Functions -- VLookup
Excel’s VLOOKUP Function How to Use It and How to Nest It
How to Use VLOOKUP Function Excel VLOOKUP tutorial
Vlookup. Excel Vlookup Formula Explained. Learn Excel Vlookup Formula
Stop The #N-A! Error in VLOOKUP and other Lookup Functions

vba userform controls

using a tree control

excel user forms

Excel-VBA userforms 101 and FAQ - Xtreme Visual Basic Talk
X Factor user forms
SplashScrn
Create User Forms in Microsoft Excel
Excel VBA Code For Excel UserForms & Controls
ExcelUser -- Programming Excel

more vba

Excel’s VLOOKUP Function How to Use It and How to Nest It

Excel VBA: No Experience Necessary - Lesson 1
Excel VBA: No Experience Necessary - Lesson 2
Excel VBA: No Experience Necessary - Lesson 3
Excel VBA: No Experience Necessary - Lesson 4
Excel VBA–No Experience Necessary: Lesson 5



Sub TestPings() Dim cell As Range Dim astr() As String
Excel FAQ - Excel 101 - Xtreme Visual Basic Talk
Excel - My Excel Pages
Examples
Getting Started with Macros and User Defined Functions
VB(A) functions
Excel for Windows Visual Basic for Applications 101
Regular Expressions
regexp Patterns
VB(A) functions
Excel - Xtreme Visual Basic Talk
Excel FAQ - Excel 101 - Xtreme Visual Basic Talk
Kickbutt VBA Find Function - Excel Help & VBA Help
excel-vba-findall-method


=========================================================
Sub Comp()
Dim rSource As Range, rTarget As Range, SourceRow%, TargetRow%

Set rSource = ActiveWorkbook.Sheets(2).Range("A2").CurrentRegion
Set rTarget = ActiveWorkbook.Sheets(1).Range("A2").CurrentRegion

For SourceRow = 2 To rSource.Rows.Count
For TargetRow = 2 To rTarget.Rows.Count
If rSource.Cells(SourceRow, 8).Value = rTarget.Cells(TargetRow, 8).Value And _
rSource.Cells(SourceRow, 3).Value = rTarget.Cells(TargetRow, 3).Value And _
rSource.Cells(SourceRow, 6).Value = rTarget.Cells(TargetRow, 6).Value Then
rTarget.Cells(TargetRow, 4).Value = rSource.Cells(SourceRow, 4).Value
rTarget.Cells(TargetRow, 5).Value = rSource.Cells(SourceRow, 5).Value
rTarget.Cells(TargetRow, 7).Value = rSource.Cells(SourceRow, 7).Value
End If
Next TargetRow
Next SourceRow
End Sub

excel VBA

VBA find the REAL last used cell - Tek-Tips
VBA identify UsedRange OR last/first column/row etc. Tek-Tips
VBA So where exactly do I put this macro code then?? Tek-Tips

VBA Tips A Pop-up Calendar for Excel

Pearson Software Consulting, LLC excel pages
Anthony's Excel VBA Page - Excel Tutorial - Excel Consultant - Excel Consulting
Range Object and Cells Property

Help and Tips on Excel MacrosThe Programming Tools

Testing Macros in the Visual Basic Editor for Excel

"Dell OpenManage Deployment Toolkit, Utiliity"

Introduction Dell OpenManage Deployment Toolkit Version 1.3 Command Line Interface Reference Guide
Query Active Directory for Information About a User
Searching Active Directory
Band-in-a-Box QuickStart Tutorial: 128k WMV .zip download
Making a New Song Arrangement

Creating Exchange Users with Excel (Part 1)

==========================================
Looping Through Cells in a Named Range
http://www.mindspring.com/~tflynn/excelvba.html
The following example loops through each cell in a named range by using a For Each...Next loop. If the value of any cell in the range exceeds the value of limit, the cell color is changed to yellow.
Sub ApplyColor()
Const Limit As Integer = 25
For Each c In Range("MyRange")
If c.Value > Limit Then
c.Interior.ColorIndex = 27
End If
Next c
End Sub

Hilltop Lab fancy scripts ADSI Scripting for Administering Windows 2000/2003 Networks

http://www.rlmueller.net/products.htm