Go4Expert

Go4Expert (http://www.go4expert.com/)
-   C++ (http://www.go4expert.com/forums/cpp/)
-   -   Issue with program to Auto-save excel in C++ (http://www.go4expert.com/forums/issue-program-auto-save-excel-cpp-t29006/)

haroonrulz 4Sep2012 12:31

Issue with program to Auto-save excel in C++
 
Dear Gurus/Experts in C++,

I am creating an automation tool, for that I have to autosave the excel with strings.I can read/write in excel, but when I try to

auto-save the excel I am getiing error, the same code I tried for saving the integers,its working but for string I am getiing error -

"IDispatch::GetIDsOfNames("saved")failed w/err 0x80020006". Please look at the code below and help me.

//Auto-save for Integers -- Working

{
VARIANT x;
x.vt = VT_I4;
x.bstrVal = ::SysAllocString(L"D:\\output.xls");
AutoWrap(DISPATCH_PROPERTYPUT, NULL, pXlBook, L"Saved", 1, x);
}

//Same for Strings -- Not Working

{
VARIANT fname;
fname.vt = VT_BSTR;
fname.bstrVal=::SysAllocString(L"D:\\output3.xls") ;
AutoWrap(DISPATCH_METHOD, NULL, pXlBook, L"Saved", 1, fname);
}


All times are GMT +5.5. The time now is 09:47.