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)
 
Back
Top