My Account
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Jan 26, 2015
4:12
:24
pm
BYUCoug11
why a macro?
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
BYUCoug11
Previous username
SFBayCoug
New username
Mike Honcho
Bio page
BYUCoug11
Joined
Feb 27, 2011
Last login
Jan 3, 2017
Total posts
0 (0 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