Creating multiple applications in Excel VBA

[Stuart Duncan]

Hi

I use Excel to gather information from employees in an office. This is done
with a userform that writes into an Access database.

I want to create a second instance of Excel to gather another set of data
too but Excel will obly open one instance of itself.

Can anyone tell me what code I need to add in order to make my userforms
into applications in their own right?

I think it has something to do with Application objects.

Thanks

Stuart Duncan

 

[Cindy M.]

Hi Stuart,

I use Excel to gather information from employees in an office. This is done
with a userform that writes into an Access database.

I want to create a second instance of Excel to gather another set of data
too but Excel will obly open one instance of itself.

Can anyone tell me what code I need to add in order to make my userforms
into applications in their own right?

Why a new instance and not a new workbook in the same instance? What you
propose will be extremely memory intensive...

In any case, using the New keyword (New Excel.application) or using the older
CreateObject Create("Excel.application") should start a new instance.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail