|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 14th, 2004, 12:33 AM
|
|||
|
|||
Forcing Excel to save as a different file name
Hi,
I am trying to get an Excel file, which I want to use as a Master File, to save as a different name when users fill in some of the fields. ie Field 1 = User Name.......... The file will automatically save as "User Name". Anyone know if this can be done? Thanks in advance -- Phil 
|
|
#2
July 14th, 2004, 12:44 AM
|
|||
|
|||
|
Forcing Excel to save as a different file name
Phil, try something like this
ActiveWorkbook.SaveAs Filename:=Range("A1").Value & ".xls" -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "philtraynor" wrote in message ... Hi, I am trying to get an Excel file, which I want to use as a Master File, to save as a different name when users fill in some of the fields. ie Field 1 = User Name.......... The file will automatically save as "User Name". Anyone know if this can be done? Thanks in advance -- Phil
|
|
#3
July 14th, 2004, 04:41 PM
|
|||
|
|||
|
Forcing Excel to save as a different file name
Where am I supposed to enter that script?
-- Phil "Paul B" wrote: Phil, try something like this ActiveWorkbook.SaveAs Filename:=Range("A1").Value & ".xls" -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "philtraynor" wrote in message ... Hi, I am trying to get an Excel file, which I want to use as a Master File, to save as a different name when users fill in some of the fields. ie Field 1 = User Name.......... The file will automatically save as "User Name". Anyone know if this can be done? Thanks in advance -- Phil
|
|
#4
July 14th, 2004, 09:42 PM
|
|||
|
|||
|
Forcing Excel to save as a different file name
Ok, nevermind....I figured it out. Thanks very much for your help. It seems to have solved my issue.
-- Phil "philtraynor" wrote: Hi, I am trying to get an Excel file, which I want to use as a Master File, to save as a different name when users fill in some of the fields. ie Field 1 = User Name.......... The file will automatically save as "User Name". Anyone know if this can be done? Thanks in advance -- Phil
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel File will not open if Excel is no open first | Vyyk Drago | General Discussion | 2 | June 23rd, 2004 01:14 PM |
| Possible to save versions in an Excel file? | Android | Worksheet Functions | 6 | May 26th, 2004 06:58 PM |
| "Excel file locked by [user]" though user is the one trying to open it! | Lady Layla | Setting up and Configuration | 0 | May 12th, 2004 02:12 PM |
| Save Excel file with preview in open file dialog box | Suzanne | Worksheet Functions | 2 | April 21st, 2004 05:15 PM |
| Time to save Excel file on Network | Ron & Joan Adams | Worksheet Functions | 2 | April 12th, 2004 08:36 AM |
Linear Mode
