Trying to automate it on this function: Workbook_BeforeClose, so it saves a

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

Report problem with this ad

Jan 26, 2015
4:13:27pm

snowbird

Trying to automate it on this function: Workbook_BeforeClose, so it saves a

a value only copy to the destination each time the workbook is closed.

This message has been modified

Originally posted on Jan 26, 2015 at 4:13:27pm

Message modified by snowbird on Jan 26, 2015 at 4:15:08pm

Report problem with this ad

snowbird

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