Why not just do the "move or copy" option on the tab?

Sign up, and you'll be able to ignore users whose posts you don't want to see. Sign up

Report problem with this ad

Jan 26, 2015
4:11:37pm

Ragnar Danneskjold

Why not just do the "move or copy" option on the tab?

Copy it to the new workbook, then select the entire tab, then paste as values only?

Report problem with this ad

Ragnar Danneskjold

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