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 ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Shell Puzzler - “Documents and Settings†folder issue? 5
Shell and Wait 3
Execute .bat File Within VBA 1
SHELL syntax? 2
using Shell to open an MS Excel file and run a macro 6
Invoke Command Line (Shell Method with Winzip) 1
Using Shell to open Excel file 1

Top