| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - save to current location vs excel default location
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default save as location in Microsoft Query | Excel Discussion (Misc queries) | |||
| default save location on network | Excel Discussion (Misc queries) | |||
| Changed Excel 2003 startup now won't save to default location | Excel Discussion (Misc queries) | |||
| Using Macro to Save Copy of File to New Location | Excel Discussion (Misc queries) | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Hybrid Mode
