LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
external usenet poster
 
Posts: 1
Default want VB6 to edits Excel in background and not become visible when I open another excel file

"Michael D. Ober" wrote in message

Unfortunately this also causes excel to ignore ShellOpen requests
when you double-click on an excel file.

Mike Ober.

"Tom Ogilvy" wrote in message
...
In the instance of excel controlled by VB6, do

oExcel.IgnoreRemoteRequests = True

This should cause user initiated workbooks to open in a separate
instance.


I knew it was too good to be true. It' a royal pain when an app that has
been running for several minutes building a report is killed by a user
opening an unrelated excel document and then closing it.

--
Reply to the group so all can participate
VB.Net: "Fool me once..."

 
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
Open EXCEL.exe in Background using a .BAT File Sunil Excel Discussion (Misc queries) 0 June 17th 09 11:49 AM
strange problem: excel file does not open and background freezes i EdH Excel Discussion (Misc queries) 2 April 21st 06 02:00 AM
no worksheets are visible when I open a file by a right click njvbguy Excel Programming 1 September 19th 05 05:29 AM
How to open file in the background. It is possible? Andrzej Excel Programming 1 June 1st 05 01:35 AM
How to open file in the background. It is possible? Andrzej New Users to Excel 1 May 31st 05 10:46 PM


All times are GMT +1. The time now is 11:18 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"