Re: $$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-24 Thread tony . kilduff
------- > >*From:* "tony.k...@seattle.gov " > > *To:* excel-...@googlegroups.com > *Sent:* Monday, February 23, 2015 6:28 PM > *Subject:* $$Excel-Macros$$ Importing data from Access changes worksheet > name > > Hi all, > I'm pulling

Re: $$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-24 Thread Paul Schreiner
015 6:28 PM >Subject: $$Excel-Macros$$ Importing data from Access changes worksheet name > > > >Hi all, >I'm pulling data from an Access DB query table. When I do, it changes the >name of the active worksheet and I don't want that. How to I pull the data >but

$$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-23 Thread tony . kilduff
Hi all, I'm pulling data from an Access DB query table. When I do, it changes the name of the active worksheet and I don't want that. How to I pull the data but keep the tab name as it was? Here's the code I'm using: ChDir "G:\Work Program\2015" Workbooks.OpenDatabase Filename:= _