LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Creating an private Excel.Application

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
Search this Thread:

Advanced Search
Display Modes

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
Private Sub Worksheet_Change(ByVal Target As Excel.Range) [email protected] Excel Worksheet Functions 0 December 21st 06 02:13 AM
Creating a Chart in a C# Application... Roe Charts and Charting in Excel 0 August 29th 06 09:55 PM
Is there a freeware application for creating gant charts in excel Bryant Charts and Charting in Excel 1 September 16th 05 08:16 PM
How can I use Excel XP to track Federal/State/Private Grants? Mike Webb New Users to Excel 0 March 16th 05 03:11 PM
macro to close excel application other than application.quit mary Excel Programming 1 September 14th 04 03:43 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"