Workbook Activate Occasion
This occasion will run code at any time when this particular workbook is activated.
Workbook AddinInstall Occasion
This occasion will run when the precise workbook is put in as Add-In in Excel.
Workbook AddinUninstall Occasion
This occasion will run when this workbook is uninstalled from Excel's Add-Ins.
Workbook AfterSave Occasion
This Occasion will run after the precise workbook is saved.
Required Parameters
Success – The success parameter is a Boolean knowledge sort that may return a worth of true if the workbook efficiently saved. If the workbook failed to avoid wasting then the success parameter will return a worth of false.
Workbook AfterXmlExport Occasion
This occasion will run after exporting XML map inside an excel workbook.
Required Parameters
Map – The map parameter returns the exported XML map as an XMLMap object. This permits customers to govern the XML map or show varied XML map attributes.
URL – The URL parameter returns the a string location of the place the XML map is being saved to.
Outcome – The outcome parameter returns a worth of true if the XML map efficiently saved and a worth of false if the worth failed to avoid wasting correctly.
Workbook AfterXmlImport Occasion
This occasion will run after importing a brand new or refreshing an already created XML map inside this particular excel workbook.
Required Parameters
Map – The map parameter returns the exported XML map as an object. This permits customers to govern the article or show varied attributes.
IsRefresh – The IsRefresh parameter returns a worth of True if the XML map is being refreshed and returns a worth of false if the map is being imported for the primary time.
Outcome – The outcome parameter can return three totally different values. If the XML being refreshed or imported incorporates an excessive amount of knowledge to suit into the workbook then the outcome parameter will return the worth of xlXmlImportElementsTruncated. If the XML being refreshed or imported is profitable then the outcome parameter will return a worth of xlXmlImportSuccess. If the XML being refreshed or imported doesn’t match the XML schema specified then the outcome parameter will return a worth of xlXmlImportValidationFailed.
Workbook BeforeClose Occasion
This occasion will run earlier than a workbook closes.
Required Parameters
Cancel – The cancel parameter is unique set to False when the occasion begins. If the cancel parameter is about to worth of True then the workbook is not going to shut.
Workbook BeforePrint Occasion
This occasion will run earlier than a workbook prints.
Required Parameters
Cancel – The cancel parameter is unique set to False when the occasion begins. If the cancel parameter is about to worth of True then the workbook is not going to print.
[ad_2]Supply by Matthew S Demaine