How to change a sheet name without opening the workbook
 

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

How to change a sheet name without opening the workbook
 

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 he

http://www.appspro.com/conference/Da...rogramming.zip

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

How to change a sheet name without opening the workbook
 

On Sep 9, 8:59*am, GS wrote:
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 he

*http://www.appspro.com/conference/Da...rogramming.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

How to change a sheet name without opening the workbook
 

On Sep 9, 10:09*pm, Andrew wrote:
On Sep 9, 8:59*am, GS wrote:









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 he

*http://www.appspro.com/conference/Da...rogramming.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

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