| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Brilliant Gary. Thanks it works
 Prashanth "Gary Keramidas" wrote: > wild guess here. > > worksheets(1).select if it's always the first worksheet. > > > -- > > > Gary > > > "helphelp" <(E-Mail Removed)> wrote in message > news:7E884D36-41EB-402A-800F-(E-Mail Removed)... > >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 > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Run macro from shape when runnig macro in Excel 2007 | bren | Microsoft Excel Discussion | 4 | 5th Dec 2009 09:03 PM |
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Pman | Microsoft Excel Misc | 4 | 29th May 2008 06:29 PM |
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | =?Utf-8?B?R2F2aW4=?= | Microsoft Excel Worksheet Functions | 0 | 17th May 2007 01:20 PM |
| Difficulty of creating a macro? | TylerLange | Microsoft Excel Programming | 3 | 6th Jun 2006 11:02 AM |
| Macro difficulty in Word 97 | Jack | Microsoft Word Document Management | 7 | 4th Apr 2005 06:43 PM |
