If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
determine if Excel is open
Hi,
i have te following code behind a button: ' Create an instance of Excel and add a workbook Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Add Set xlWs = xlWb.Worksheets("Sheet1") The only problem is, if users click the button 20 times, there are 20 instances of Excel open on the machine, thereby slowing computer performance. I want Excel to be oneped ONLY if it is not currently opened on the users machine to prevent multiple excel instances. how can I achieve this? Thanks in advance, -geebee |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
CSV formatted files open odly in Excel 2000 | Janski | General Discussion | 3 | November 24th, 2005 07:58 PM |
Click on Excel Doc Starts Excel but Excel does not Open the Doc. | Mark | General Discussion | 3 | August 24th, 2005 02:33 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
cannot open workbook outside of excel | jnc | General Discussion | 4 | July 14th, 2004 11:01 AM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |