Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
|
|||
|
|||
want VB6 to edits Excel in background and not become visible when I open another excel file
I currently load an excel file using VB6 as below:
Set oExcel = CreateObject("excel.application") Set oBook = oExcel.Workbooks.Open(sMyFile) Set oSheet = oBook.Sheets(1) oSheet.cells(1,1)=... I then proceed to manipulate the worksheet for a while. The Excel file doesn't show in Windows while it is doing its processing but obviously the process shows in the task manager under processes. If I know open another Excel file from Windows for general use (nothing connected to my VB6 application), The file above becomes visible and it is possible to edit the file. What is more if you then close the file above the VB6 loses the link to the file. Is it possible to open up my VB6 Excel file in a separate process so that if the user then wants to open another Excel file meanwhile the VB6 Excel file will not become visible? Any help really appreciated David |
#2
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
|
|||
|
|||
want VB6 to edits Excel in background and not become visible when I open another excel file
In the instance of excel controlled by VB6, do
oExcel.IgnoreRemoteRequests = True This should cause user initiated workbooks to open in a separate instance. -- Regards, Tom Ogilvy "Zee" wrote in message ups.com... I currently load an excel file using VB6 as below: Set oExcel = CreateObject("excel.application") Set oBook = oExcel.Workbooks.Open(sMyFile) Set oSheet = oBook.Sheets(1) oSheet.cells(1,1)=... I then proceed to manipulate the worksheet for a while. The Excel file doesn't show in Windows while it is doing its processing but obviously the process shows in the task manager under processes. If I know open another Excel file from Windows for general use (nothing connected to my VB6 application), The file above becomes visible and it is possible to edit the file. What is more if you then close the file above the VB6 loses the link to the file. Is it possible to open up my VB6 Excel file in a separate process so that if the user then wants to open another Excel file meanwhile the VB6 Excel file will not become visible? Any help really appreciated David |
#3
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
|
|||
|
|||
want VB6 to edits Excel in background and not become visible when I open another excel file
Works great! Thanks a lot
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
|
|||
|
|||
want VB6 to edits Excel in background and not become visible when I open another excel file
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. -- Regards, Tom Ogilvy "Zee" wrote in message ups.com... I currently load an excel file using VB6 as below: Set oExcel = CreateObject("excel.application") Set oBook = oExcel.Workbooks.Open(sMyFile) Set oSheet = oBook.Sheets(1) oSheet.cells(1,1)=... I then proceed to manipulate the worksheet for a while. The Excel file doesn't show in Windows while it is doing its processing but obviously the process shows in the task manager under processes. If I know open another Excel file from Windows for general use (nothing connected to my VB6 application), The file above becomes visible and it is possible to edit the file. What is more if you then close the file above the VB6 loses the link to the file. Is it possible to open up my VB6 Excel file in a separate process so that if the user then wants to open another Excel file meanwhile the VB6 Excel file will not become visible? Any help really appreciated David |
#5
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
|
|||
|
|||
want VB6 to edits Excel in background and not become visible when I open another excel file
I thought that was the point.
-- Regards, Tom Ogilvy "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. -- Regards, Tom Ogilvy "Zee" wrote in message ups.com... I currently load an excel file using VB6 as below: Set oExcel = CreateObject("excel.application") Set oBook = oExcel.Workbooks.Open(sMyFile) Set oSheet = oBook.Sheets(1) oSheet.cells(1,1)=... I then proceed to manipulate the worksheet for a while. The Excel file doesn't show in Windows while it is doing its processing but obviously the process shows in the task manager under processes. If I know open another Excel file from Windows for general use (nothing connected to my VB6 application), The file above becomes visible and it is possible to edit the file. What is more if you then close the file above the VB6 loses the link to the file. Is it possible to open up my VB6 Excel file in a separate process so that if the user then wants to open another Excel file meanwhile the VB6 Excel file will not become visible? Any help really appreciated David |
#6
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
|
|||
|
|||
want VB6 to edits Excel in background and not become visible when I open another excel file
You need to remember to put in the line oExcel.IgnoreRemoteRequests = False
before you issue oExcel.Quit. If you don't, you won't be able to double-click on an excel spreadsheet on your desktop and have excel open it. Mike Ober. "Tom Ogilvy" wrote in message ... I thought that was the point. -- Regards, Tom Ogilvy "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. -- Regards, Tom Ogilvy "Zee" wrote in message ups.com... I currently load an excel file using VB6 as below: Set oExcel = CreateObject("excel.application") Set oBook = oExcel.Workbooks.Open(sMyFile) Set oSheet = oBook.Sheets(1) oSheet.cells(1,1)=... I then proceed to manipulate the worksheet for a while. The Excel file doesn't show in Windows while it is doing its processing but obviously the process shows in the task manager under processes. If I know open another Excel file from Windows for general use (nothing connected to my VB6 application), The file above becomes visible and it is possible to edit the file. What is more if you then close the file above the VB6 loses the link to the file. Is it possible to open up my VB6 Excel file in a separate process so that if the user then wants to open another Excel file meanwhile the VB6 Excel file will not become visible? Any help really appreciated David |
#7
Posted to microsoft.public.excel.programming,microsoft.public.vb.ole.automation,microsoft.public.vb.general.discussion,comp.lang.basic.visual.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open EXCEL.exe in Background using a .BAT File | Excel Discussion (Misc queries) | |||
strange problem: excel file does not open and background freezes i | Excel Discussion (Misc queries) | |||
no worksheets are visible when I open a file by a right click | Excel Programming | |||
How to open file in the background. It is possible? | Excel Programming | |||
How to open file in the background. It is possible? | New Users to Excel |