Results 1 to 3 of 3

Macro to Create Download File

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2010
    Location
    Toledo, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    6

    Macro to Create Download File

    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.
    Last edited by MikeHun; 12-08-2010 at 03:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1