Posted to microsoft.public.excel.programming

Rich[_16_] Rich[_16_] is offline

external usenet poster

Posts: 22

Multiple instances of Excel and VB

I am using VB6 and Excel 97.

I have a problem where if the is an instance of Excel is open with an
open workbook. And I try to do OLE Automation, then the data from one
report, ends up on the spreadsheet that happened to be open at the
time.

What can I do so that when I dump data into a spreadsheet, it will not
disturb other instances of Excel.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple instances of Excel (Multiple workbooks)	Shane	Setting up and Configuration of Excel	3	November 13th 09 05:07 PM
Using RTD with multiple instances of excel	[email protected]	Excel Discussion (Misc queries)	0	February 13th 09 10:51 AM
Multiple Instances of EXCEL.EXE	MKG	Excel Discussion (Misc queries)	3	February 3rd 07 12:08 AM
Multiple Instances of Excel	David Z	Excel Discussion (Misc queries)	18	July 1st 06 02:26 PM
Multiple instances of Excel	Carol Crowley	Excel Discussion (Misc queries)	9	March 17th 06 06:18 PM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us