How to change a sheet name without opening the workbook

[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

 

[GS]

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

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]

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

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

Andy

 

[lifescholar]

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

Andy

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