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
5:28
:37
pm
Cougar8Duck
Change the VBA so that it saves the original file at the beginning of the close,
then performs the code (which edits the original), but then then code closes without saving.
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
Cougar8Duck
New username
Mr Salad
Bio page
Cougar8Duck
Joined
Jul 2, 2010
Last login
Oct 28, 2023
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