LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default VBA to VBS Translation - References

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data translation pfdubz Excel Discussion (Misc queries) 4 July 23rd 08 02:32 AM
Translation of VBA from PC to MAC alina b. Excel Programming 4 June 26th 06 07:00 PM
Value translation Sheldon Excel Programming 1 September 28th 04 09:16 PM
RNG translation DiZzY Excel Programming 2 May 19th 04 08:08 PM
Need Translation Phil Hageman Excel Programming 1 July 25th 03 03:19 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"