Macro - save to current location vs excel default location

leezard

Guest

Posts: n/a

28th Oct 2008

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?

« Conditional Formatting - Increases/Decreases | Self canceling checkboxes »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to Insert Current Date into cell - Macro to "Save As"	Guy	Microsoft Excel Worksheet Functions	4	12th Dec 2008 09:20 PM
current week, current month, current year	joemeshuggah	Microsoft Excel Programming	1	14th Oct 2008 06:44 PM
Macro - Save an Open Excel Version 4 as current version of Excel	planomax	Microsoft Excel Programming	1	6th Feb 2007 10:41 PM
Default save on exit for ppt should be 'do save' not 'don't save'	=?Utf-8?B?cHVibGljaXR5c2h5?=	Microsoft Powerpoint	3	11th Aug 2006 06:48 PM
File.Save does not really save the current (or complete) status of the excel workbook (XL2000)	Gerhard Braendle	Microsoft Excel Discussion	3	19th May 2004 11:48 PM