you could append the date or something onto the end of the filename

Sign up, and you can customize which countdowns you see. Sign up

Report problem with this ad

Jan 26, 2015
4:33:09pm

BYUCoug11

you could append the date or something onto the end of the filename

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