Workbook Activate Party
This occasion will operate code when this particular workbook is activated.
Workbook AddinInstall Function
This function will run when the certain workbook is set up as Add-In in Excel.
Workbook AddinUninstall Event
This party will run when this workbook is uninstalled from Excel's Incorporate-Ins.
Workbook AfterSave Celebration
This Celebration will run following the distinct workbook is saved.
Achievement – The accomplishment parameter is a Boolean facts variety that will return a worth of true if the workbook effectively saved. If the workbook unsuccessful to save then the achievement parameter will return a price of untrue.
Workbook AfterXmlExport Event
This function will run soon after exporting XML map inside of an excel workbook.
Map – The map parameter returns the exported XML map as an XMLMap object. This lets buyers to manipulate the XML map or display several XML map attributes.
URL – The URL parameter returns the a string locale of exactly where the XML map is currently being saved to.
Result – The consequence parameter returns a value of accurate if the XML map properly saved and a worth of untrue if the price unsuccessful to save effectively.
Workbook AfterXmlImport Celebration
This function will run immediately after importing a new or refreshing an already produced XML map inside this distinct excel workbook.
Map – The map parameter returns the exported XML map as an object. This allows people to manipulate the item or display screen a variety of characteristics.
IsRefresh – The IsRefresh parameter returns a price of Real if the XML map is currently being refreshed and returns a value of fake if the map is currently being imported for the 1st time.
Final result – The final result parameter can return three diverse values. If the XML being refreshed or imported contains also significantly info to match into the workbook then the end result parameter will return the worth of xlXmlImportElementsTruncated. If the XML getting refreshed or imported is effective then the result parameter will return a value of xlXmlImportSuccess. If the XML currently being refreshed or imported does not match the XML schema specified then the end result parameter will return a price of xlXmlImportValidationFailed.
Workbook BeforeClose Party
This celebration will operate just before a workbook closes.
Cancel – The cancel parameter is authentic established to False when the celebration begins. If the terminate parameter is established to value of Real then the workbook will not shut.
Workbook BeforePrint Celebration
This event will run prior to a workbook prints.
Terminate – The terminate parameter is unique set to Wrong when the occasion starts. If the cancel parameter is established to price of Real then the workbook will not print.