Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joseph Geretz
 
Posts: n/a
Default How do I isolate my Excel server (automation) from other Excel instances?

Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user then
hits X to exit their document (this is the normal user approach) this shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all toolbars.
I'm finding that now when the user opens their own documents, their favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!

- Joe Geretz -

P.S. How come there's no excel.vba group like there is for Word?


  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
only for your last question:
excel.programming

Though most regulars also read this .misc NG anyway

--
Regards
Frank Kabel
Frankfurt, Germany

Joseph Geretz wrote:
Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other
Excel documents, these documents all share the same Excel window. If
the user then hits X to exit their document (this is the normal user
approach) this shuts down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all
toolbars. I'm finding that now when the user opens their own
documents, their favorite toolbars are gone. Again, it's the same
basic issue. How do I isolate our own Excel server from other
instances of Excel in the user's environment?
Thanks for your help!

- Joe Geretz -

P.S. How come there's no excel.vba group like there is for Word?



  #3   Report Post  
Stephen Bullen
 
Posts: n/a
Default

Hi Joseph,

Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user then
hits X to exit their document (this is the normal user approach) this shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all toolbars.
I'm finding that now when the user opens their own documents, their favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!


To fix the underlying problem, you can set
Application.IgnoreRemoteRequests=True to make Windows start a new instance of
Excel when the user double-clicks an xls. You might also need/want to set
Application.Interactive=False. There's still the chance of someone getting your
instance of Excel if they double-click a workbook that's embedded in a Word
document (for example), which you might be able to avoid by starting *two*
instances of Excel (untested) - one for you to use, one to accept the COM
requests.

P.S. How come there's no excel.vba group like there is for Word?


Public.Excel.Programming fulfills that purpose for Excel.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk


  #4   Report Post  
Joseph Geretz
 
Posts: n/a
Default

Thanks guys!

excel.programming - I missed that one. See you there in the near future, I'm
sure!

- Joe Geretz -

"Stephen Bullen" wrote in message
...
Hi Joseph,

Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user
then
hits X to exit their document (this is the normal user approach) this
shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all
toolbars.
I'm finding that now when the user opens their own documents, their
favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!


To fix the underlying problem, you can set
Application.IgnoreRemoteRequests=True to make Windows start a new instance
of
Excel when the user double-clicks an xls. You might also need/want to set
Application.Interactive=False. There's still the chance of someone getting
your
instance of Excel if they double-click a workbook that's embedded in a
Word
document (for example), which you might be able to avoid by starting *two*
instances of Excel (untested) - one for you to use, one to accept the COM
requests.

P.S. How come there's no excel.vba group like there is for Word?


Public.Excel.Programming fulfills that purpose for Excel.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk




  #5   Report Post  
 
Posts: n/a
Default

i've got a solution for you

get rid of excel and start using Access.

better yet, use Access Data Projects-- store the data in SQL Server; and
then you won't have to worry about Excel automation; since you can get to
the real data using real tools




"Joseph Geretz" wrote in message
...
Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user

then
hits X to exit their document (this is the normal user approach) this

shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all

toolbars.
I'm finding that now when the user opens their own documents, their

favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!

- Joe Geretz -

P.S. How come there's no excel.vba group like there is for Word?






  #6   Report Post  
Junior Member
 
Posts: 1
Smile

Stephen.. These two VBA commands have made a world of difference in my automation processes.

THANKS!!!


Application.IgnoreRemoteRequests=True
Application.Interactive=False

line codes from Stephen Bullen; Microsoft MVP - Excel
Reply
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
Excel Automation SelectionChange event cpotts Excel Discussion (Misc queries) 1 December 20th 04 06:15 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 01:07 AM


All times are GMT +1. The time now is 04:10 PM.

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

About Us

"It's about Microsoft Excel"