Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Visual Builder Excel Plugin - Pre Upload Macro — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Visual Builder Excel Plugin - Pre Upload Macro

Accepted answer
edited Apr 23, 2020 4:17PM in Visual Builder 6 comments


How o create Pre Uplaod Macro in Excel Plugin


I'm trying to use pre upload plugin , the documentation mentions that the macro should return true. The functions return value are not detected.

Function GetAmount() As Boolean
     MsgBox "Done1"

 GetAmount = True

End Function

The above function returns true, but plugin fails with error below.


Information: Oracle.VisualBuilder.Excel.Runtime.Status.LayoutStatusViewer.Notify: Invoking pre-upload macro: {0}...

Verbose: oacw.excel.om.api.ExcelApplication.Run: Attempting to run macro: GetAmount()
Verbose: oacw.excel.om.api.ExcelApplication.Run: Macro run complete. Return value: -2146826273
Verbose: Oracle.VisualBuilder.Excel.Runtime.Table.TableUploadHelper.InvokePreUploadMacro: Unable to parse macro return value: -2146826273 (Int32)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!