Creating a Workbook Copy

nickm687

Guest

Posts: n/a

3rd Apr 2007

Hi there,

I have a Workbook that contains macros.

What i need is to create an exact copy of this active workbook in the
same directory and run a macro stored on the new copy.

Does this make sense lol.

Any help will be greatly appreciated.

Kind Regards
Nick

« Code help: Combing data from worksheets in a directory. | Check if file Is Accessible »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Autofilter Source Workbook A result in Destination Workbook BSheet1	u473	Microsoft Excel Programming	1	9th Sep 2008 05:14 PM
Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist	pete.bastin@btopenworld.com	Microsoft Excel Programming	4	18th Jun 2006 06:08 PM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook	burl_rfc	Microsoft Excel Programming	1	1st Apr 2006 08:48 PM
Creating a Backup copy of workbook	=?Utf-8?B?anVzdGFndXlmcm9ta3k=?=	Microsoft Excel Programming	3	3rd Mar 2006 11:02 PM
Copy a range of cells in an unopened workbook and paste it to the current workbook	topstar	Microsoft Excel Programming	3	24th Jun 2004 12:50 PM