Macro - save to current location vs excel default location

Discussion in 'Microsoft Excel Misc' started by leezard, Oct 28, 2008.

  1. leezard

    leezard Guest

    I have an Excel 2003 spreadsheet containing a macro to create new
    spreadsheets. Here's how it works - Open WorkBook1, run Macro1, which
    creates WorkBook2, Workbook3…etc. from WorkBook1.
    This works great for one client. All of the created WorkBooks (2,3 etc..)
    are created in the same folder as WorkBook1.
    For other clients the WorkBooks (2,3 etc..) are created in the default save
    folder for Excel not where WorkBook1 is located.
    What is the difference?
     
    leezard, Oct 28, 2008
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    3
    Views:
    433
    Guest
    Apr 20, 2004
  2. Guest
    Replies:
    0
    Views:
    249
    Guest
    Dec 21, 2004
  3. Guest

    save workbook as current date using a macro

    Guest, Jun 20, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    194
    Dave Peterson
    Jun 21, 2006
  4. Guest
    Replies:
    2
    Views:
    146
    Guest
    Nov 9, 2006
  5. Guest
    Replies:
    11
    Views:
    611
    Dave Peterson
    Jun 28, 2007
Loading...

Share This Page