To correctly invoke Office automation COM APIs using up-to-date C++, you can use the following steps:
#include <Windows.h>
#include <atlbase.h>
#include <atlcom.h>
HRESULT hr;
TCHAR szProgID[] = _T("Excel.Application");
CLSID clsid;
hr = CLSIDFromProgID(szProgID, &clsid);
ATLENSURE_SUCCEEDED(hr);
CComPtr<IDispatch> spExcelApp;
hr = CoCreateInstance(clsid, NULL, CLSCTX_LOCAL_SERVER, IID_IDispatch, (void**)&spExcelApp);
ATLENSURE_SUCCEEDED(hr);
CComVariant svarResult;
CComDispatchDriver pDisp(spExcelApp);
hr = pDisp.GetPropertyByName(L"Version", &svarResult);
ATLENSURE_SUCCEEDED(hr);
wprintf(L"Excel version: %ls\n", svarResult.bstrVal);
Note that the above example is for Excel application and the ProgID for other Office applications might be different. Also, ensure that you use appropriate error handling techniques, like exceptions or HRESULT checking, for robustness.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-03-14 11:00:00 +0000
Seen: 10 times
Last updated: Jun 04 '22
What does an empty name signify in the inotify_event structure in the C++ language?
What is the method to get a printable output of a C++11 time_point?
What are the differences between TREEFROG, CROW, and the CPPCMS C++ framework?
How can the NTP flag be set for Linux time in C++?
What is the process of redefining a c++ macro with fewer parameters?
What are some other options instead of Scipy to compute CubicSpline?
How can a list be sorted alphabetically within a console application?