Hi folks
I use a spreadsheet i made up myself for vehicle estimates
Is it possible when a certain cell has text entered, the spread sheet will save when closed with the text that has been entered into the cell.
I.e. car registration no for instance SMO2 NAV has been entered to cell G10.
The reason for this request is a couple of guys that work for me keep saving the original blank estimate, as blank estimate so i come along open up the estimate template and there is an estimate filled in.
Heh
I feel your pain.
Same thing happens with the templates I make for the people I work with, I get calls asking for another copy of the original cause they save over the original.
Yes it's possible, and not too difficult.
I'll post some code in a bit if no one else beats me to it.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Why not just make the template read-only?
Entia non sunt multiplicanda sine necessitate
I use something along the lines of :
where newname is a string which I've referred to a cell with
Please Login or Register to view this content.
ThanksOriginally Posted by mewingkitty
I use something along the lines of :
where newname is a string which I've referred to a cell withPlease Login or Register to view this content.
i should have added in my original post i am a bit of a self taught novice i will need step by step instructions to implment this procedure
Curious: What do you mean by 'template'?
Is it just a normal XLS workbook with areas where data is entered?
Or, is it an XLT file?
If it's just an xls file, then Excel does not treat it as and Excel template.
For instance, given some file, MyForm.xlt, when opened, Excel will automatically rename the open file to MyForm1.xls. When an attempt to save the file is made, it will only save it if that name has not already been used. Otherwise, you will get the ...already exists... dialog requesting a new name.
The original MyForm.xlt file will not be modified.
Last edited by protonLeah; 12-06-2009 at 04:03 PM.
Ben Van Johnson
Yes it is just saved as a workbook with each new estimate that is created.
I just made sure that the original was saved as a template named "blank estimate.", then i tried not saving as some of my workers do.
The template automatically ask if you want to save "blank estimate1" so i said yes as my non computer literate workers would probaly do. Then open template again and carry out the same procedure default save name is again "blank estimate1" witch will naturally overwrite the previous one.
Just need an easy way to allow the workbook save automatically for text that is entered into cell g10
Thank for the replys so far :-)
Last edited by dunsdale.coachw; 12-06-2009 at 06:20 PM.
The code below will prompt for a registration number when the template is first opened . It will put the registration number in cell G10 and immediately save the file using the registration number in cell G10 as the new name.
---------------------Please Login or Register to view this content.
How to install the User Defined Function:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Double click on ThisWorkbook in the left pane treeview
4. Copy and Paste in your code (given above)
5. Modify the line:
to reflect your actual paths foldersPlease Login or Register to view this content.
6. Get out of VBA (Press Alt+Q)
7. Save your workbook template
Please try on a test copy of your template first.
The code below will prompt for a registration number when the template is first opened . It will put the registration number in cell G10 and immediately save the file using the registration number in cell G10 as the new name.
---------------------Please Login or Register to view this content.
How to install the User Defined Function:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Double click on ThisWorkbook in the left pane treeview
4. Copy and Paste in your code (given above)
5. Modify the line:
to reflect your actual paths foldersPlease Login or Register to view this content.
6. Get out of VBA (Press Alt+Q)
7. Save your workbook template
Please try on a test copy of your template first.
protonLeah
thanks :-)
thanks :-)
thanks :-)
Most sincerely
That is excellant bit of help, works a treat should save me some headaches.
I am well pleased you made my monday morning, thank's again.
Kind regards Nick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks