Petroleum Office: Troubleshooting #NAME? Error

Submitted by admin on Sun, 05/07/2017 - 13:06

1. Check the Petroleum Office license status under Petroleum Office Tab => Settings button on ribbon => Licensing section. If license is expired of trial expired, functions from add-in would not be loaded.

2. Check if Petroleum Office is active in Excel add-in list. There must be 2 Petroleum Office add-ins - one is Excel add-in, another is COM add-in, both must be active.

petroleum office addin troubleshooting

How To Use Petroleum Office Addin Functions From VBA

Submitted by admin on Thu, 04/27/2017 - 12:42

The easiest way is to use Application.Run(...). The first argument should be the function name (unadorned by any library names), followed by the arguments to the add-in function. The Application.Run() method will convert Excel COM data types (such as Ranges, variants and arrays) to the appropriate data types before calling the add-in function. It will also convert the result into a COM Variant type.

Example:

Discussion example

Submitted by admin on Thu, 04/27/2017 - 12:42

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed ut mollis arcu. Curabitur et metus neque. Sed quis urna venenatis, volutpat orci vel, egestas lacus. Cras auctor a leo eu hendrerit. Cras metus mi, commodo et luctus id, consequat vitae enim. Sed a sem nec sapien euismod tempus ut id mi. Integer nec dolor iaculis, rhoncus diam non, mattis nulla. Fusce sapien mi, facilisis eget facilisis condimentum, tincidunt a est. Etiam nec pharetra lacus. Phasellus a diam leo. Praesent gravida a enim at laoreet. Nullam sed orci ultrices, rhoncus lectus eu, mollis tellus.