Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in opening Excel which is already opened by VB code
Hi,
I have a VB programmming coded by my senior programmers. It will take data from Access database and puts it into an excel file and formats. Since we require a lot of formating after the data being spooled to excel we have written a VB code. When we run VB programs it opens the excel sheet in the background and does its work. If we open excel directly for any other purpose will get runtime error from VB application and program aborts. Is there any method by which we can use excel in parallel to the application (which uses excel internally)? Please let me know if you have any solutions Regards, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in opening Excel which is already opened by VB code
Open a separate instance of Excel to do your processing. Keep the new instance invisible (the default state). See... http://support.microsoft.com/kb/219151/en-us Jim Cone Portland, Oregon USA "Naveen J V" wrote in message Hi, I have a VB programmming coded by my senior programmers. It will take data from Access database and put it into an excel file and formats. Since we require a lot of formating after the data being spooled to excel we have written a VB code. When we run VB programs it opens the excel sheet in the background and does its work. If we open excel directly for any other purpose will get runtime error from VB application and program aborts. Is there any method by which we can use excel in parallel to the application (which uses excel internally)? Please let me know if you have any solutions Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when opening up file in Excel 2007, but not when opened withExcel 2002 | Excel Programming | |||
Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but | New Users to Excel | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming |