How to create folder with VBA 6

[SkyHigh]

Hi Folks

Can someone please show me how to check the existence of a folder and if it does not exist then create it using VBA.

Thanks for your help
Brenda

 

[BillPower]

Hi Danvlas,

I just got an email from BusMgr:
===============================================
Bill:

I am having a problem with my code very similar to the posting that you responded to above. I created a posting under Automation Error. Is my problem that the Windows Scripting is Diabled on my clients computer for virus reasons? My code will work on one computer sitting next to the clients that will not work. I use the
Set fs = CreateObject("Scripting.FileSystemObject&quot and I receive an error -

Automation Error
The specified module could not be found.

Thanks for any help.

Regards
Karl R. Spring
aka BusMgr
==================================================

I didn't think to ask myself, but how does a user Enable/Disable Windows Scripting Host and how do we as programmers test for it being Enabled/Disabled.

Thanks

Bill Power.

 

[danvlas]

Enabling/disabbling WSH:
Control Panel-Add/Remove Programs/Windows Setup/Accessories/Details
Scroll down to Windows Scripting Host and check/uncheck the box.

Testing...Since CreateObject fails with error 429.
Trapping the error is simple.

Thanks for the star(s).






Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[BusMgr]

Dan

I don't mean to sound dumb, but on the enable/disable WSH feature.

Control Panel-Add/Remove Programs-Add/Remove Windows Components-??

The only option that I have is Script Debugger.

Am I missing it or going to the wrong program option?

Thanks for your help.

Regards
BusMgr

 

[danvlas]

What OS? I was talking about Win 9x.
Never used Win 2K or NT.

Looks like XP...I guess the WSH is hidden somewhere else.

I'll check it out tomorrow.




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[BusMgr]

Win2K

Thanks

BusMgr