Excel Issue
-
Hi, I want to read a text in an excel file. I am using the folowing code. HRESULT hr; CLSID clsid; hr = CLSIDFromProgID(L"Excel.Application", &clsid); BOOL bRet = objApp.CreateDispatch(clsid); objBooks = objApp.GetWorkbooks(); objBooks.Open("C:\\tmp\\1.xls", VOptional, VOptional,VOptional,VOptional,VOptional, VOptional, VOptional, VOptional, VTrue, VFalse, VOptional, VOptional); It is working in a test applicaiton. But i am using the same code in my development project, CreateDispatch function gets failed. Anyone knows the reason? Thanks,
-
Hi, I want to read a text in an excel file. I am using the folowing code. HRESULT hr; CLSID clsid; hr = CLSIDFromProgID(L"Excel.Application", &clsid); BOOL bRet = objApp.CreateDispatch(clsid); objBooks = objApp.GetWorkbooks(); objBooks.Open("C:\\tmp\\1.xls", VOptional, VOptional,VOptional,VOptional,VOptional, VOptional, VOptional, VOptional, VTrue, VFalse, VOptional, VOptional); It is working in a test applicaiton. But i am using the same code in my development project, CreateDispatch function gets failed. Anyone knows the reason? Thanks,
Use second parameter of
CreateDispatchto check what's causing it to fail. See COleDispatchDriver::CreateDispatch [^] for it's usage.