EPM – Executing VBA and API Functions with Excel Macro

image

To turn on the Developers tab, go to the Office Button → Excel Options
→ Select Show Developer tab in the Ribbon → OK.

To use buttons in Excel templates, you must first access visual basic and turn on the
FPMXLClient via Tools → References

Custom VBA Functions – Event Based
You can customize your VBA code by associating the events listed below. You can use
these custom functions when you build Visual Basic for Applications (VBA) modules.
• BEFORE_CONTEXTCHANGE – Use this function to execute a custom operation
before changing the context.
• AFTER_CONTEXTCHANGE – Use this function to execute a custom operation
after changing the context.
• BEFORE_REFRESH – Use this function to execute a custom operation before
the system refreshes the data.
• AFTER_REFRESH – Use this function to execute a custom operation after the
system refreshes the data.
• BEFORE_SAVE – Use this function to execute a custom operation before the
system saves data into the database.
• AFTER_SAVE – Use this function to execute a custom operation after the system
saves data into the database. The return values to use for all these events are:
true or false.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s