Got it. This is where I step out...

Sign up, and you'll be able to vote in polls. Sign up

Report problem with this ad

Jan 26, 2015
4:14:38pm

Ragnar Danneskjold

Got it. This is where I step out...

Report problem with this ad

Ragnar Danneskjold

Previous username: CougarSkye
Bio page: Ragnar Danneskjold
Joined: Sep 2, 2011
Last login: May 7, 2024
Total posts: 70,746 (30,782 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