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:
    505
    Guest
    Apr 20, 2004
  2. Guest

    Template default save location?

    Guest, Oct 23, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    172
    Frank Kabel
    Oct 23, 2004
  3. Guest
    Replies:
    0
    Views:
    299
    Guest
    Dec 21, 2004
  4. Guest

    save workbook as current date using a macro

    Guest, Jun 20, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    217
    Dave Peterson
    Jun 21, 2006
  5. Guest
    Replies:
    2
    Views:
    185
    Guest
    Nov 9, 2006
  6. Guest
    Replies:
    11
    Views:
    669
    Dave Peterson
    Jun 28, 2007
  7. Guest

    default save location on network

    Guest, Aug 22, 2007, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    169
    Guest
    Aug 23, 2007
  8. ngg

    Default save as location in Microsoft Query

    ngg, Aug 8, 2008, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    177
Loading...