Is there a way that I can have an excel document "autosave"?
Specificaly I would like: If a value in a specific cell's value is changed I would like the document to automatically save the document as the name of the value that is typed into that cell when the user closes the document.
I'm not sure if this is possible, but it would be great if there was some way to do this.
Thanks in advance for any help!
Hi add this to the Thisworkbook code moduleand add this to the top of a standard module (note: it does not need Sub....End Sub around it, simply put it at the top of the module)
Please Login or Register to view this content.now when changing A1 on sheet1 the workbook will be saved as that (as long as the workbook has been saved once, i.e not Book1 but saved as a name)Please Login or Register to view this content.
Not all forums are the same - seek and you shall find
very good reply,learned something from your code
Glad i could be of help
Simon,
Thank you! I have not tried this yet but I will. I just wanted to be sure to thank you for your help. I will let you know! Thanks!
Um....forgive me for this. But, what do you mean by a standard module?
How to add and run a MacroOriginally Posted by whatsmyname
1. Copy the macro above placing the cursor to the left of the code box hold the CTRL & Left Click, then Right Click selected code and Copy.
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.
To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.
Thank you that works. I keep getting an error though. When I click back onto the cell to change the data again, it prompts me and says that the file already exists do I want to replace it? Is there any way to not get that message?
After I click no on that pop up window, excel promps me with:
A Microsoft Visual Basic window with a message that says: [Method 'Save As' of objects'_workbook' failed]
I can either pick "END" "DEBUG" "HELP"
What do I do wrong?
Also, is there a way that I can get the save to seperate each file that I save to their own folders by date?
Example: If I do 40 tickets in one day(9-14-09). When I save each file, I would like to be able to go to the folder that I am saving them and open up just a folder for that date(9-14-09). I'm not sure if that can be done. It would be great though.
Thank you for your help!
replace this linewith this onePlease Login or Register to view this content.Please Login or Register to view this content.
Okay,
I replaced that line of code with the one you said too. It didn't do anything, not even autosave. But, While I was doing that I noticed that I had an error. I repaired the error and replaced the code back with the original, and it works perfectly. The only thing is if I leave the cell blank then it promps me with the debug error box again.
How about making it save to a new folder that it creates with the date of the ticket?
Simon? Simon? SIMONNNNNNN!!!????. hahahaha.
I was curious if my question on the previous post was possible and how can I do that?
Any help would be greatly appreciated.
Replace Thisworkbook.Path for something like "C:\blah\blah\" & Range("A1").value &"\" where A1 would be the filename.
Does this look right?
[ThisWorkbook.SaveAs ("C:\AllUsers\MyDocuments\" & Range("A1").Value & "\")]
This code will sort all of the folders by date?
A quick explanation of what I'm trying to do: I have a an excel file that is named "Work Order". When a user opens up that file the date is in a cell that automatically changes every day to the current date Then the user types into another cell the value that I would like to save the file as. But if that user does 10 of these "Work Orders" a day, then I would still like them to be saved as the value that was typed into the cell, but I would like all of the files to be automatically saved into folders seperated by date.
I hope I explained that good.
Thank you for your help.
Last edited by whatsmyname; 09-16-2009 at 02:30 PM.
If anyone else out there that knows or understands what I am doing I would greatly appreciate your help also.
Thank You!!!
Do you already have all these folders in one location?
No I do not. I do have a folder that I want all of these folders to save too though.
I hope that this is possible. If anybody else can help me out with this I would greatly appreciate it.
Provided your template workbook is stored in the same area (My Documents) and you have a folder for each day of the month (full name for each month) then this will work
, of course you can write code to check if the directory and folder exist and if not create one or both!Please Login or Register to view this content.
Thanks Simon,
Can you show me how to write code so the program will check for those folders and if they do not exist creat one?
I really appreciate all your help.
Hmmmm, i don't mind helping but seriously, do a little research, tinker with the code and then get help to give it that final polish.
There are plenty of examples out there for check dir and mkdir.
Okay, thank you Simon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks