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
25
Views
6
Comments
edited Apr 23, 2020 4:17PM in Visual Builder 6 comments

Summary

How o create Pre Uplaod Macro in Excel Plugin

Content

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.

Register

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