| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In 2007 I am having difficulty distinguishing highlighted areas | Excel Discussion (Misc queries) | |||
| 2007 Compatibility Mode Difficulty | Excel Discussion (Misc queries) | |||
| Experiencing Difficulty with Excel | Excel Worksheet Functions | |||
| Difficulty of creating a macro? | Excel Programming | |||
| Opening Excel Application difficulty | Excel Discussion (Misc queries) | |||
Linear Mode
