PC Review


Reply
Thread Tools Rate Thread

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?

 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:06 AM.