Hi,
I'd like to have a macro run when an excel file is opened. It should create a back-up of the same file and save it in the same directory with different name so it can be differentiated as a backup.
I can find macros that do similar things, but usually when a file is saved, not opened...Any suggestions?
Last edited by Barking_Mad; 06-18-2010 at 05:14 AM.
Try:
Please Login or Register to view this content.
The code needs to be placed on the ThisWorkbook code page of your workbook's VBA project.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Perfect, thanks muchly
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks