Run a MSDos Command from Excel
 

I have created a very simple DIR batch file that list files in a given
folder w/subfolders to a TXT file. This I'd like to run by clicking a
object (menu button). Like if one where toassign a Macto to a image.

The path to the Batch file is looooong and there are looong folder
names..

Any ideas, tips or comments??

Run a MSDos Command from Excel
 

Shell("path") is the VBA command to run an external program.



"FrodeOlsen" wrote:

I have created a very simple DIR batch file that list files in a given
folder w/subfolders to a TXT file. This I'd like to run by clicking a
object (menu button). Like if one where toassign a Macto to a image.

The path to the Batch file is looooong and there are looong folder
names..

Any ideas, tips or comments??