Macros, Tabs and other files

J

Jim

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
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros Tabs and Files 7
Macros for figure borders 1
Synchronization problems while moving folders to new email 1
Import text file with macro - Invalid argument (Error3001) 0
Converting excel to PDF, single page converts to multiple HELP! 1
Want to have macro execute automatically when doc created 3
Macro Code for bringing up Save As dialog box and changing file Type 0
Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0

Top