Difficulty with macro in excel 2007.

[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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Gary Keramidas]

wild guess here.

worksheets(1).select if it's always the first worksheet.

 

[helphelp]

Brilliant Gary. Thanks it works

Prashanth

wild guess here.

worksheets(1).select if it's always the first worksheet.