Saving CSV to a template

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

Guest

I am trying to setup a spreadsheet for another office. I need make it
possible to save the csv (overwrite previous file) as an excel worksheet.
And have available the macro I recorded to reformat the csv file.

The person that will be using the other file is not all that computer savy.
So I need to make it as simple as possible.

Any suggestions?

Also, in the macro I will be recording, one of the things it will be doing
is renaming the worksheet tab. The tab will be different, depending on the
tab name the csv file will generate. Is there a way to have the macro rename
the tab regardless of what it is originally?
 
Hi Josh,
Hope this will at least help you rename the sheet.
Sub Macro1()
ThisSheet = ActiveSheet.Name
Sheets(ThisSheet).Select
Sheets("Sheet1").Name = "Rename" '<--Rename needs to change appropriately
End Sub
 
You must log in or register to reply here.

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

Looping Open and Save as CSV 9
Saving Multiple Tabs as CSV 4
copy and save as csv 4
Save All Worksheets as CSV 7
Want Macro to save to .xlsx 2
CSV files and having numbers and strings in there... 9
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Save Excel file to a CSV without opening it first 4

Back
Top