Run dos command with macro

[Jonsby]

Hi,

I'm trying to use VBA to run a few dos commands but I kinda have no idea how to do this.

I want to use the command "dir C:\test /b >test.csv"
and then open that file in excel.

This is quite a basic question but i think once I know how it works I can just expand on it.

Sorry if I was vague on the explanation

Thanks

[Andy Pope]

Have a look at the help on the SHELL command.