Running a Macro but Sheet name changes; leading to DEBUG error

Hello,

I wanted to know how would you work around the following problem.

So I have a button on Excel that runs a Macro on my Excel.

When ever I click on the option to import the Data I am working with into excel, the default sheet name is "Download(1)".

The line from my macro looks something like this...
#

Please Login or Register  to view this content.

#

Lets say while Download(1) is still active I go and import the same data again, then the sheet name"Download(1)" changes to Download(2) and so on...

So if it becomes "Download(2)" I would receive a Debug error because the code has "Download(1)"

what would I have to do so I never have to worry about the changing number in the parenthesis causing my code to need debugging???

Please let me know if there is further clarification needed.

Hi Swade,

If you always download the sheet to the left most sheet it will always be Worksheets(1). The short answer is try to use Sheet Indexes instead of their specific name.

See:

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

The last worksheet will be:

Worksheets(sheets.count)

Here is an inclusive link about worksheets...

http://www.cpearson.com/Excel/SheetNameFunctions.aspx

I think you are getting the technique.. Read the second link I just put on my last thread.

I do all the testing in my immediate pane to see if VBA like it or not. Then I copy it into my code.

How is the code importing the data?

How do you import it?

Could you import it to a specific worksheet, perhaps via Data>Web Query?