Martin said:
Where and how can I find resources, help and explanation, for the
'scripting' facilities in VBA, in particular the 'file system object'?
Thank you
Martin
One way is to open the VBA editor, go to Tools > References, and check the
box next to "Microsoft Scripting Runtime"; then type FileSystemObject into
the help search box. The reference (which you'll need anyway in order to use
scripting objects in your macros) links the scripting help into the VBA help
system.
Another way is to use the MSDN Library, which is mostly the same stuff
you'll find in the help. Start at
http://msdn.microsoft.com/library/d...en-us/vbenlr98/html/vaobjfilesystemobject.asp
and follow the See Also links.
Also, search Google with the terms
FileSystemObject VBA
Here are a couple of the better hits:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office09072000.asp
http://www.techbookreport.com/tutorials/fso1.html
Finally, be aware that the scripting runtime is not "in" VBA, although VBA
can use it. (That's why you have to set an explicit reference to it.)
Scripting is an external resource that's available to VB, VBA, VBScript, and
other languages. You may want to look at other tutorials and examples that
don't specifically mention VBA.
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
