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

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/Da...rogramming.zip

HTH

--
Garry

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

On Sep 9, 8:59*am, GS <g...@somewhere.net> 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 here:
>
> *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

On Sep 9, 10:09*pm, Andrew <andrewkgent...@gmail.com> wrote:
> On Sep 9, 8:59*am, GS <g...@somewhere.net> 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 here:
>
> > *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.