Ya, thanks. This issue with that is that it overwrites the orginal file.

Sign up, and CougarBoard will remember which categories you want to view. Sign up

Report problem with this ad

Jan 26, 2015
4:31:50pm

snowbird

Ya, thanks. This issue with that is that it overwrites the orginal file.

This message has been modified

Originally posted on Jan 26, 2015 at 4:31:50pm

Message modified by snowbird on Jan 26, 2015 at 4:31:59pm

Message modified by snowbird on Jan 26, 2015 at 4:33:47pm

Report problem with this ad

snowbird

Bio page: snowbird
Joined: Nov 1, 2008
Last login: Apr 16, 2024
Total posts: 18,127 (970 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