Adding new workbook in vba without activiting the just created

marika

New Member

Join Date: Oct 2008

Posts: 1

24th Oct 2008

Hey all!

I would like to create a new workbook with vba.

Is there any other way to create workbook than workbook.add?
This method activates the new workbook, and this is not what i want, as it disturbs my original process.. Or is there way to tell to workbook.add not activate the new book?

If any ideas, I will be happy.

-marika

Last edited by marika; 24th Oct 2008 at 08:06 PM.. Reason: Wrong title

« Hyperlink jpg files in Dir via VBA | An alternative for the edate function... »

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
Adding a chart to large workbook brings workbook activity to a hal	Dale	Microsoft Excel Misc	6	29th Dec 2008 05:50 PM
Activiting a tab in TabControl programatically...	Charlie@CBFC	Microsoft Dot NET Framework Forms	1	29th Mar 2007 10:26 PM
link to not-yet-created workbook	=?Utf-8?B?Y2pheA==?=	Microsoft Excel Misc	2	8th Mar 2006 08:10 PM
Adding Code to the This_workbook module of a created workbook	RPIJG	Microsoft Excel Programming	1	9th Jul 2004 06:35 PM
Shared border created in FP 2003 and adding to the pages created in FP 98	=?Utf-8?B?TXIuIFNoYWg=?=	Microsoft Frontpage	4	9th Jan 2004 10:58 AM