4

My first question on the site, so hopefully I'm doing this right.

I use file juggler on my windows machine. The program can watch for new files and trigger run commands.

When a new csv file arrives I would like a run command that would open that file in excel.

Thanks

5

If you include the Office directory that contains Excel.exe, then you don't need to explicitly set the path in your command line. The simplest thing to try is just type excel.exe and the CSV file name after it.

Otherwise, you will have to set the path explicitly. Using double quotes for excel and double quotes for the CSV is best:

"c:\program files\microsoft office\office12\excel.exe" "c:\newfile.csv" 
  • Hey Sun, Thank you so much. I had to use the explicit path but it works perfectly! – Dean Mar 17 '14 at 23:37
  • 1
    When loading a CSV file in Excel this way, all the CSV columns fall in Excel's column 'A'. Is there a way, from the command line to indicate what the column separator is? – Hans Deragon Mar 26 '18 at 14:46
  • Question is out of scope. You can try here superuser.com/questions/238944/… or use Excel macro to activate to process csv as you want – Sun Mar 27 '18 at 18:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.