Macro to Create Download File

[MikeHun]

I am trying to record a Macro that when pushed will do the following:

1. Create New Workbook
2. Copy Data from Original File and Paste Special: Values into the New Workbook
3. Delete Generic Sheet 2 and Sheet 3 in New Workbook
4. Rename Sheet 1 to SalesExpense

Everything in that string works nicely except for #1, everytime the macro opens a new workbook it calls it Book 3, Book 4, Book 5 etc.. My question is what do I need to do that it will open it as the same number or any fix really.

Thanks in advance.

[Richard Buttrey]

Hi,

You need to save the Workbook. i.e.

Please Login or Register  to view this content.

HTH

[MikeHun]

Works Perfectly, I appreciate the help.