Difficulty with macro in excel 2007.
 

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

Difficulty with macro in excel 2007.
 

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


"helphelp" wrote in message
...
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

Difficulty with macro in excel 2007.
 

wild guess here.

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


--


Gary


"helphelp" wrote in message
...
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

Difficulty with macro in excel 2007.
 

Brilliant Gary. Thanks it works :)

Prashanth

"Gary Keramidas" wrote:

wild guess here.

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


--


Gary


"helphelp" wrote in message
...
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