Save to two different locations

**phoztek** · 02-18-2011, 06:26 AM

Hi all,

I want my workbook to save to two different specified locations. After pressing the button it will copy the values of the table to another table.
And after i wanted this to copy the active workbook to another location.

Meaning that it would open the Antonio Tasks.xls and replace the table and save. And after create a coy of Antonio Tasks.xls in another location ( like a backup )

Is this possible ?

PS: I'm using the code below and have tried to implement it but can only save once.

Please Login or Register  to view this content.

Thanks for all the help !!!

**Greg M** · 02-18-2011, 08:28 AM

Hi there,

In view of the fact that you're closing the workbook immediately after you've saved it, a simple way to create a second copy of the workbook is to add the following line of code between your ".Save" and ".Close" statements:

Please Login or Register  to view this content.

Hope this works - please let me know how you get on.

Regards,

Greg M

**phoztek** · 02-21-2011, 01:31 PM

Originally Posted by Greg M

Hi there,

In view of the fact that you're closing the workbook immediately after you've saved it, a simple way to create a second copy of the workbook is to add the following line of code between your ".Save" and ".Close" statements:

Please Login or Register  to view this content.

Hope this works - please let me know how you get on.

Regards,

Greg M

Thanks Greg, it worked like a charm.

Cheers

**Greg M** · 02-21-2011, 01:53 PM

Hi again,

Many thanks for your feedback - glad I was able to help.

Regards,

Greg M

Save to two different locations

LinkBack

Thread Tools

Rate This Thread

Display

Save to two different locations

Re: Save to two different locations

Re: Save to two different locations

Re: Save to two different locations

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions