Save as Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with 3 sheets, one of which contains a file name in the
following format: "WE-MMDDYY". I need a macro that will save this workbook
as a CSV file with the name derived from the worksheet with the "WE-MMDDYY"
format.

Any help would be greatly appreciated.
 
ActiveWorkbook.SaveAs Range("A1").Text, FileFormat:=xlCSV

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Opening a .csv file 6
Save As Macro 3
Importing .txt data into Excel 1
problems getting this macro to work 23
Saving .xls without macro 2
Save or Export to CSV 2
Annoying problem saving sheet w/macros as CSV 11
File Save As macro for users with different paths 6

Back
Top