Office Connector Web Help | Online Help |
Event Macros |
Contents | Index |
Office Connector Import can call macros that you record to run at specific time, for example just before saving an import file, so you can carry out steps tied to events in the workbook.StepsFollow these steps to record a macro tied to a Office Connector Import event:
Event Macros List
Advanced UsageThe default Before and After event macro functionality can be extended by manually editing the recorded macro procedures.Canceling an EventAll of the events that start with Before_ can be canceled, preventing the action from taking place. To accomplish this, change the macro from a Sub to a Function that returns a Long. To cancel the action, assign a non-zero return value to the function. For example:Public Function Before_WriteImportFiles() As Long 'Don't save unless there is a job number If IsEmpty(Range("A1")) Then Call MsgBox("You must enter a job number before saving the import file.", _ vbInformation) Before_WriteImportFiles = -1 Exit Function End If End Function Using Return ValuesAll of the events that start with After_ can be modified to indicate if the action was successful. To accomplish this, add a Long parameter to the Sub. Office Connector Import will pass the return code from the associated action via this parameter. Zero indicates success and other values indicate cancellation or errors. For example:Public Sub After_WriteImportFiles(ByVal lvOperationResult As Long) 'Don't do anything if the save was canceled or did not complete due to an error If lvOperationResult <> 0 Then Exit Sub End If 'Run the code to perform post-save steps here End Sub |