Refresh workbook from command prompt

Hi guys/girls

Is it possible to refresh all my data in my excel workbook using a command line in command prompt?

I have a 40+ csv files all link to my workbook. These csv are generated using command prompt, and i need to refresh my workbook, before following on with the next command.

Many thanks

Ian

Interesting question. In my opinion (and of course I could be wrong) I dont think you could do this from a command prompt since your operating environment is outside of the VBE. You may be able to do something with VB.Net.

Why not build a refresh method into your main or controlling sheet? When this completes then you can activate your next command?