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