Combining VBA with MS-DOS

What are you trying to do in DOS? Most things that DOS can do can also be done in Excel directly, which would be a lot more straightforward.

If you really, really must use DOS then the obvious thing to do would be to have Excel create a batch file (a text file with a .BAT extension) which can then be run. A batch file can contain any DOS commands, or indeed any instructions that are recognised at the command line.

Edited to add: Something like this, perhaps...

Please Login or Register  to view this content.

Heh, it's been *ages* since I wrote a batch file.