Thread: want VB6 to edits Excel in background and not become visible when I open another excel file
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
Bob Butler Bob Butler is offline
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..."

Reply With QuoteReply With Quote