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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest
    Replies:
    3
    Views:
    525
    Guest
    Apr 20, 2004
  2. Guest

    Template default save location?

    Guest, Oct 23, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    189
    Frank Kabel
    Oct 23, 2004
  3. Guest
    Replies:
    0
    Views:
    321
    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:
    235
    Dave Peterson
    Jun 21, 2006
  5. Guest
    Replies:
    2
    Views:
    202
    Guest
    Nov 9, 2006
  6. Guest
    Replies:
    11
    Views:
    723
    Dave Peterson
    Jun 28, 2007
  7. Guest

    default save location on network

    Guest, Aug 22, 2007, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    236
    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:
    187
Loading...