Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Set this at the beginning after you create the application
With Application .IgnoreRemoteRequests = True End With Set it back just before you close the application and before you close the last workbook. With Application .IgnoreRemoteRequests = False End With Haven't tested it, but I believe this will do what you want. -- Regards, Tom Ogilvy "Chet Cromer" wrote in message ... I have an application that uses an Excel.Application object to print numerous reports and other information while the program is running. Currently I create an excel.application each time I need to create a report and then .quit it and set it to nothing when I'm done. This causes quite a delay when you have to keep opening and closing Excel. What I'd like to do is have a single Excel.Application that runs the whole time the application is running. The problem with this is that if the user goes elsewhere and double clicks an Excel file, it opens up in my application's object. THen when they exit Excel, my object is no longer valid. How can I create an Excel.Application object that isn't accessible to the user when they double click a file to open it? Thanks, Chet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Sub Worksheet_Change(ByVal Target As Excel.Range) | Excel Worksheet Functions | |||
Creating a Chart in a C# Application... | Charts and Charting in Excel | |||
Is there a freeware application for creating gant charts in excel | Charts and Charting in Excel | |||
How can I use Excel XP to track Federal/State/Private Grants? | New Users to Excel | |||
macro to close excel application other than application.quit | Excel Programming |