This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have created a basic COM add-in for MS office apps like Word, PPT, Excel in Visual C++ using _IDTExtensibility2 interface.
Now i want my add-in to find if Word, PPT, Excel has any unsaved changes.
FYI: I have not chosen VSTO or Office JS add-in due to dependency/deployment reasons.
Kindly provide solution in C++.
You should review the object models for each of Excel, Word and PowerPoint. If you look carefully you will see that the Excel workbook object, the Word document object and the PowerPoint presentation object each have a Saved property which will give you the information you want.
// _IDTExtensibility2 Methods
public:
CComQIPtr<Word::_Application> pWordApp;
CComQIPtr<Word::_Document> pWordDoc;
STDMETHOD(OnConnection)(LPDISPATCH Application, ext_ConnectMode ConnectMode, LPDISPATCH AddInInst, SAFEARRAY * * custom)
{
pWordApp = Application;
pWordApp->get_ActiveDocument(&pWordDoc);
if (pWordDoc)
{
MessageBoxW(NULL, L"ActiveDocument present", L"Native Addin", MB_OK);
}
else
{
MessageBoxW(NULL, L"ActiveDocument not present", L"Native Addin", MB_OK);
}
VARIANT_BOOL prop = VARIANT_FALSE;
pWordDoc->get_Saved(&prop);
if (prop)
{
MessageBoxW(NULL, L"Saved=True", L"Native Addin", MB_OK);
}
else
{
MessageBoxW(NULL, L"Saved=False", L"Native Addin", MB_OK);
}
return S_OK;
}
I tried using Saved property for Word. The build generation went success for the following code but when i open word i didn't get the active document object i.e., i get "ActiveDocument not present" message box.
Maybe it is too early to call get_activedocument() method as during onConnection the document is yet to be created. But i don't know how/where to call get_activedocument() method once document is created.
I tried calling it inside onStartupComplete() too, still object is NULL. I also tried creating a thread and call this method inside the thread after sleeping for few seconds so that i could create a new document when that thread is sleeping, still object is NULL.
I am not sure what i am missing.
Kindly guide along with some sample C++ code/projects as the MS documentation is only available in C#/VB.
FYI: I have added my code sample as comment.
Maybe it is too early to call get_activedocument() method as during onConnection the document is yet to be created. But i don't know how/where to call get_activedocument() method once document is created.
Yes, that's a problem. Since I previously provided you a sample Add-in for a TaskPane I updated the sample to provide some minimal functionality. All the previous comments about how it was created are still in effect. The updated sample can create a TaskPane in Excel and Word. The ActiveX control hosted by the TaskPane now includes two items - an edit control that identifies which Office application it is loaded into and a button that checks the Saved property.
For Excel -
and
For Word -
and
The updated Add-In can be obtained at s!AmnqrCFBv4nDgiLKcnfX4cf0S2a0
Is there any method/something which will run always when add-in is active? If it is available, i can add a something like a loop which will periodically check Saved property and show UI/update (task pane) if needed.
The point of updating the sample Add-in was simply to demonstrate retrieving useful information for the Saved property. The sample was never intended to address all possible circumstances, including multiple documents.
Why do you want to continually look for unsaved changes. Don't Office applications have an AutoSave capability? Don't they prompt to save changes when a document or workbook is closed?
I want to continually look for changes in order to find if user is editing. I earlier tried key press events detection, but it detects unwanted too many key press events too. So now i am thinking to use Saved property.
Is there any method/event handler/something which will run always when add-in is active?
You could use a timer.