Difficulty with macro in excel 2007.

  • Thread starter Thread starter helphelp
  • Start date Start date
H

helphelp

I have a website from which I download data and run macros for sorting data.
When I recors a macro in excel 2007, the macro looks for a specific file name
instead of using the active worksheet. For eg:
Sheets("userexport-23").Select. Everytime I download the -23 changes, Please
tell me how I can change the code to make the macro run in any worksheet.
Thanks

Prashanth
 
It sure would help if you posted the code you are talking about and also
tell us what the -23 changes to... otherwise, all we can do is take wild
guesses.

Rick
 
Back
Top