Excel VBA-How to save sheet w/in all workbooks as sheet1?

  • Thread starter Thread starter waveracerr
  • Start date Start date
W

waveracerr

I have a file, KeyWest.xls, that contains all of my macros. Through
macro I can open all delimited files from a directory and into excel.
Only problem is that excel will save the single worksheet of data i
each workbook as the file name which will interfere with a macro.
need excel to save the worksheet in each workbook as "sheet1". N
matter if it does it while opening the delimited file, after all file
or open, etc. Any assistance would be much appreciated!

Thanks,

Rya
 
Ryan,

After opening each one, issue this command.

Activeworkbook.Activesheet.Name = "Sheet1"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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

Macro for all Excel Workbooks to print to PDF 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Always open a workbook on Sheet1 regardless of sheet viewed when lastsaved 2
How to split an excel workbook in code and data 2
All Workbook Saved except This Workbook 3
copying sheet1 from different workbooks contained in a folder to myone and only destination workbook 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Save All Worksheets as CSV 7

Back
Top