I posted this question and got the answer to it. Thanks everyone who replies. I have to modify this though and I am not sure if it is possible to do so. The following is what i asked and what was answerd. My question will follow.
Originally Posted by Bafa
I have decided that it would be good to save a record on the PC of what was done as well as the hard copy I am required to keep. So what I need is for the master file I am working on to close without promting me to save it, but I do want it to save the info entered as a seperate file, preferably with the file name of the current date YY-MM-DD format. The reason is when the master file is open I want it to be void of all values, so when it closes I don't want the info that was entered to be saved there, but instead to have it automaticly create and name a new file and save all the info there upon closing the master file. So in my directory you would see a list like this:Originally Posted by mudraker
master.xls <- Never saves it self
070522.xls \
070615.xls - > These three were created by the master file closing
070728.xls /
I hope I haven't made this sound more complicated than it is. If anyone needs clairification of what I am doin please ask. Thanks everyone for all the help so far on this file I made almost a year ago and have been tweaking since. It got me the promotion at work that I wanted and reduced a 3 and a half hour difficult process down to flat 30 minute cake walk.
Bookmarks