How to change a sheet name without opening the workbook

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hello,
I am trying to figure out how, or if it is possible, to change the
name of the first sheet of each workbook in a folder. I have figured
out a way to do this by having a macro open each file, but this is
time consuming, AND, there is a macro in each workbook which tries to
run each time the workbook is opened. So, I would like to do this
without opening the files. Any ideas?

thanks,
Andy
 
Andrew pretended :
Hello,
I am trying to figure out how, or if it is possible, to change the
name of the first sheet of each workbook in a folder. I have figured
out a way to do this by having a macro open each file, but this is
time consuming, AND, there is a macro in each workbook which tries to
run each time the workbook is opened. So, I would like to do this
without opening the files. Any ideas?

thanks,
Andy
Click to expand...

You might be able to do this using ADO and SQL to rename a table since
ADO treats each worksheet in an Excel file as a table. You can download
working samples on how to work with closed files using ADO here:

http://www.appspro.com/conference/DatabaseProgramming.zip

HTH
 
Andrew pretended :



You might be able to do this using ADO and SQL to rename a table since
ADO treats each worksheet in an Excel file as a table. You can download
working samples on how to work with closed files using ADO here:

 http://www.appspro.com/conference/DatabaseProgramming.zip

HTH

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Click to expand...

Thank you. I will look at some examples and see how this is done.

Andy
 
Thank you.  I will look at some examples and see how this is done.

Andy
Click to expand...

If you are on Excel 2007/2010 you could also directly manipulate the
XML in the zipped xlsx file.
 
Back
Top