Member Avatar for haroonrulz

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, pXlSheet, L"Saved", 1, fname);
}
  • 2 Contributors
  • 1 Reply
  • 303 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by Ancient Dragon
Member Avatar for Ancient Dragon

Are you using the example code from here?

Edited by Ancient Dragon
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.