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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 macro recording feature no longer works for inserting p 4
How to force macros refer to ActiveWorkbook 2
How to call Excel add-in macro from a button… 1
Macro for all Excel Workbooks to print to PDF 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Simple Excel 2003 macro not working in Excel 2007 0
macro in excel 2007 8
How to split an excel workbook in code and data 2

Back
Top