My Account
Sign up, and you can customize which countdowns you see.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Jan 26, 2015
4:11
:37
pm
Ragnar Danneskjold
Why not just do the "move or copy" option on the tab?
Copy it to the new workbook, then select the entire tab, then paste as values only?
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
Ragnar Danneskjold
Previous username
CougarSkye
Bio page
Ragnar Danneskjold
Joined
Sep 2, 2011
Last login
Mar 28, 2024
Total posts
70,273 (30,578 FO)
Report problem with this ad
Messages
Author
Time
Excel Question
snowbird
1/26/15 4:08pm
Why not just do the "move or copy" option on the tab?
Ragnar Danneskjold
1/26/15 4:11pm
Trying to automate it on this function: Workbook_BeforeClose, so it saves a
snowbird
1/26/15 4:13pm
Got it. This is where I step out...
Ragnar Danneskjold
1/26/15 4:14pm
you've probably already found this, but...
BYUCoug11
1/26/15 4:24pm
Ya, thanks. This issue with that is that it overwrites the orginal file.
snowbird
1/26/15 4:31pm
you could append the date or something onto the end of the filename
BYUCoug11
1/26/15 4:33pm
Change the VBA so that it saves the original file at the beginning of the close,
Cougar8Duck
1/26/15 5:28pm
Do you need this to function multiple times or is it a one-off movement of data?
7H3F3RN
1/26/15 4:40pm
Run each time someone closes, which is typically daily.
snowbird
1/26/15 4:55pm
why a macro?
BYUCoug11
1/26/15 4:12pm
How about changing the order?
Cougar8Duck
1/26/15 5:35pm
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad