Stuart McLachlan
stuart at lexacorp.com.pg
Mon Apr 1 16:40:31 CDT 2013
Don't know about changing the name, but last week I wrote an application which iterates through all the worksheets in an Excel file and imports every one of them into a single table, except the worksheet called :"Summary", One field in the table is the Worksheet name. I did it on site and don't have a copy of the code, but I can get it later today and post it. -- Stuart On 1 Apr 2013 at 16:20, Brad Marks wrote: > All, > > We have an Access 2007 application that pulls data from several sources, > including an Excel file. > > There are several worksheets in the Excel file, but data is only pulled > from one worksheet. > > There is some complexity in the current process because the name of the > worksheet changes. We do not have control over this name. > > I have been thinking about a better/different approach. > > Is there some way in Access VBA code to change the name of an Excel > Worksheet? This step could be done prior to the main processing. We > could make a copy of the master Excel file and then work with our own > copy. > > I am curious if others have run into this issue when working with Excel > files and I am curious if there are ideas on how to better deal with > this. > > Thanks, > Brad > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >