table of contents


Purpose of the Context and Analysis Script

The AsInt Pull and Push workbooks generated by the Data Conduit tool are temporary items. The concept with the VBA scrip is you should be able to download and apply the VBA script to any workbook. The purpose of the script is too:

  1. Provide guidance on the fields for data collection/data entry

  2. Show only required fields


Step 1 Download the scipt

The below is an open source VBA script designed to implement in a MS Excel workbook. The download file is .txt format.

For the API 581 RBI model, please use this script - > Download file here

For the AsInt RBI+ for Fixed Equipment, please use this script -> Download file here

For the AsInt RBI+ for Tank Bottoms, please use this script -> Download file here


Step 2 Execute the Script in MS Excel

Once the script is downloaded, in a .txt format, follow the below steps to add and run the script to your workbook.

Step 1 - Open the Workbook with the data you would like to interrogate. Tap the Developer ribbon.

Please note you may have to enable the “Developer” ribbon in MS Excel. Instructions can be found here. Or google “enable developer in excel”.

(tap to enlarge image)

Step 2 - Tap the “Visual Basic Icon”

Step 3 - A VBA code editor will appear. Tap the sheet name you would like to plot the guidance too. In this case, I have selected “Sheet2”. For you, it could be any blank sheet in the workbook.

(tap to enlarge image)

Step 4 - Open the .txt field you downloaded in prior step. Any text editor will work. Select All text and copy the text.

ctrl + c for “Select All”

ctrl + c for “Copy”

Step 5 - Paste the VBA code into the VBA editor you open in Step 3. It will look a bit odd, but should look something like this image.

Note: Make sure you paste it on the sheet you selected in Step 3.

Step 6 - In the Upper right, select the drop down and choose the function “Execute the Process” and the function will now be selected.

Step 7 - Tap the “Execute” button and the code will process.

Step 8 - The code will prompt the user to indicate what sheet you want the code to show only required fields. This is the Model that you intend to push data into.

Step 9 - At the end of the process, the “Guidance” table will be plotted and only the Required Fields will be shown.