VBA Shell and Saving

B

beavetoots

I'm Opening an Excel Spreadsheet using a shell command:
Call Shell("EXCEL.exe strCreated", 1)

I would first like to be able to delete the excess sheets (Sheet3) in the
file, then
save it as a csv file. This needs to run as transparent to the user.

Anybody have any coding on this type of process? It's drving me a little
buggy ...
 
Top