Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am puzzled by my VB.NET application behavior. In the following code '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''' '''' dim ExcelApp as Excel.Application ExcelApp = GetObject(Nothing, "Excel.Application") if (ExcelApp is nothing) then ExcelApp = CreateObject("Excel.Application") endi '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''' '''' if there is an Excel process running before running this code, the variable "ExcelApp" will refer to an instance of type "System.__ComObject". But if Excel process is not present before running this code, this variable will point to an instance of "Microsoft.Office.Interop.Excel.ApplicationCla ss". If "ExcelApp" is pointing to "System.__ComObject", the code "ExcelApp.Workbooks.Add()" will succeed. But if it is pointing to the other type, this code will throw an exception which says "Object reference not set to an instance of an object". Can anybody give some advices? Many thanks in advance. Regards, -- Yi Chu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I hide unused file types from file types list in save dial | Excel Discussion (Misc queries) | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
GetObject function | Excel Programming | |||
GetObject | Excel Programming | |||
GetObject-question | Excel Programming |