Creating a new Excel instance

[G4L]

I have a spreadsheet that will retrieve real time data off Bloomberg Terminal. The only problem is that there are almost 10 spreadsheets running in Bloomberg Terminal and I don't want my spreadsheet to interfere with those spreadsheets. So is there anyway I can create a specific process/instance that only won't interfere with any other spreadsheets?

[HaHoBe]

Hi, G4L,

like this:

Please Login or Register  to view this content.

Ciao,
Holger

[G4L]

Sorry I am new to Excel but does newXL.Quit close the excel spreadsheet? I want this spreadsheet to be running 24/7.

[HaHoBe]

Hi, G4L,

that´s the whole process of setting up a new instance and closing it down. You´re correct, newXl.Quit would close down the instance and the next line destroy the object set to the instance. But the first lines of creating the new instance, making it appear on the screen could be used. Next I guess would be opening a workbook:

Please Login or Register  to view this content.

Ciao,
Holger

[G4L]

sorry for the late reply...was on vacation

anyways I'm not sure if I explained properly but I have a spreadsheet that will be open 24/7 that will be running a specific macro every 5 minutes. I will need to open other spreadsheets during the day and I want to make sure that the other spreadsheets that are opened will not be stuck or mess up any data on the aforementioned spreadsheet when the macro runs every 5 minutes.

[HaHoBe]

Hi, G4L,

AFAIR Excel can open more than one instance which will work independently. What may be affected is the use of an existing personl.xls (depending on which instance was opened first should have access to that workbook). But placing these codes in an AddIn should work around the problem.

Ciao,
Holger