Macros, Tabs and other files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I created a Macro to take a excell file (lets same its named Doggy),
sort and break up per my specs and place results on 7 different tabs. Works
good. However everytime I get a new file to convert through this Macro I
have to rename the file to Doggy before the macroo will work because that is
the name on the tab when I origionally created the macro. Here is the line
that is causing the issue - Sheets("Doggy").Select . is there a way around
this?

Thanks
 
Jim,

It apears you are using Excel. The focus of this newsgroup is macros
within Access, the database programme. You will have a better chance of
good help in an Excel related forum.
 
Back
Top