Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Information from AD to Excel Using VBScript
Hi there;
I am trying to run a script that will move account information, such as Lastname, to an Excel Document. I've never done anything with VBScript so I'm not sure how the whole thing works. I found a script that looks promising at: http://www.visualbasicscript.com/m_29830/tm.htm I tried going into Excel an going to ToolsMacroVisual Basic Editor; and then double clicking on the sheet1 and pasting the script into there. When I hit the play (or run) button I get a compilation error that highlights the "Set" and says this is an "Inalid Outside Proceedure" I'm kinda stuck and any help is appreciated. Jreg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Information from AD to Excel Using VBScript
Jreg,
You don't paste the VBScript code into an Excel worksheet. The script opens an instance of Excel and writes to it. Here is more on VBScripts you might want to read. http://visualbasic.about.com/od/lear.../vbsadmin2.htm Alan "Jreg" wrote: Hi there; I am trying to run a script that will move account information, such as Lastname, to an Excel Document. I've never done anything with VBScript so I'm not sure how the whole thing works. I found a script that looks promising at: http://www.visualbasicscript.com/m_29830/tm.htm I tried going into Excel an going to ToolsMacroVisual Basic Editor; and then double clicking on the sheet1 and pasting the script into there. When I hit the play (or run) button I get a compilation error that highlights the "Set" and says this is an "Inalid Outside Proceedure" I'm kinda stuck and any help is appreciated. Jreg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Information from AD to Excel Using VBScript
Thnx I got it running properly.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving information from one spreadsheet to another | Excel Discussion (Misc queries) | |||
Moving information between worksheets | Excel Discussion (Misc queries) | |||
moving information within a workbook | Excel Discussion (Misc queries) | |||
automaticaly moving information | Excel Programming | |||
Moving Information | Excel Worksheet Functions |