Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On May 6, 11:18 am, Matthew Pfluger
wrote: Tom, Thanks for your incredibly informative post. I appreciate the help. This will be my first crack at a VBScript, and I appreciate the help. When you say you tend to code in MSE, do you just create a new file and then export to a *.vbs file? Can you offer any other references you use for VBS coding? Thanks, Matthew Pfluger P.S. The late binding and strong variable type rules are disturbing... {snip} Concerning MSE, I tend to start with a .vbs file and open it in the IDE, but you can do it the other way. The Intelli-sense doesn't kick in until you provide a file type, so open a new project and immediately save it to a .vbs file. Debugging in the IDE is a bit problematic, because the script needs to run under the WSH host, which the IDE does not support, AFAIK. I tend to just save the file and then launch it from Explorer and deal with the syntax and runtime errors as they pop up. But, that's me - I'm sure others link to the script debugger and do it that way - its just that I've never stopped to figure it out - I get along with the trial and error approach, instead. Relative to references for scripting, Mr. Alcatel has provided a good cross reference in his response to ypur post. In addition there are the items below: Microsoft® Windows®2000 Scripting Guide (URL all one line) http://www.microsoft.com/technet/scr...e/default.mspx TechNet Script Center Sample Scripts (URL all one line) http://www.microsoft.com/downloads/d...a-b8814fe2da5a WSH 5.6 documentation download (URL all one line) http://www.microsoft.com/downloads/d...displaylang=en Tom Lavedas =========== http://members.cox.net/tglbatch/wsh/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data translation | Excel Discussion (Misc queries) | |||
Translation of VBA from PC to MAC | Excel Programming | |||
Value translation | Excel Programming | |||
RNG translation | Excel Programming | |||
Need Translation | Excel Programming |