Hi all
This may be near on impossible, but is it possible to take a copy of a spreadsheet say at 5pm every friday, even when the workbook is closed?
I know i can do this manually, but there are 9 sheets in all different locations i need to save a copy as, and want to be able to do this my just clicking a command button
is it possible?
Dan
Yes, use the filesystemobject to copy the files, or do you want the data appeneded to an existing sheet?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Nope just a complete copy of the worksheet, il give it a go thank you
You can just use VBA's FileCopy statement if you are copying the workbook. If you want an exact copy of a worksheet, you have to open the file.
Last edited by romperstomper; 07-17-2014 at 06:15 AM.
Remember what the dormouse said
Feed your head
Hi,
Is there a reason why you can't get the timer macro to open the workbook, copy the sheet and then close the first workbook?
Seems to me that that's the simplest approach.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks