DOS Commands

[Thales750]

Are more or less all of the DOS functions available through VBA?
I need to make directories, copy and rename files etc.

Thanks,

 

[wazz]

i was just looking at this recently for the first time. i *think* you have to use Shell command. check back for other replies and search for DOS, Shell, (command) prompt, etc.

 

[unknown27]

Not sure about DOS commands but for what you say youre looking to do then this should be all you need:

http://msdn.microsoft.com/en-us/library/d6dw7aeh(VS.85).aspx

ps My first post ever!!

 

[datAdrenaline]

In VBA you have ...

MkDir - make a directory
RmDir - remove a directory
FileCopy - copy a file
Name - rename a file
Kill - delete a file
SetAttr - set a file attribute

Dir - "list" your directory (read the help on this to explain what it does)
GetAttr - retrieve file attribut info
CurDir - returns the currrent directory
Environ - returns os level environ variables
FileLen - to return the size of a file ...

.....

I am sure there are more statements or functions that sort of emmulate DOS.

 

[Mike375]

I recently changed from a lot of batch files to VBA. I did this to get around having to put extra files on people's computers.

Most of mine all involved copy, date/time stamping, delete etc.

You can also use VBA to mkae batch files.

 

[Thales750]

Thanks Guys