Via vBase Workbook

The vBase Excel Library enables you to generate verifiable data and datasets directly from Excel.

The written instructions below guide you through the process using the latest version of vBase_Excel_Stamper.xlsm.

This instructional video may also be helpful in gaining an overview of the setup and stamping process.

Installation

  1. Unzip vBase_Excel_Setup_Latest.zip into a local directory on your computer.

  2. Uninstall any existing version of the library.

  3. Install the new version by running setup.exe.

  4. If open, close vBase_Excel_Stamper.xlsm.

  5. Unblock the file (if needed):

    • In Windows File Explorer, right-click vBase_Excel_Stamper.xlsm.

    • Select Properties.

    • In the General tab, locate the Security section.

    • If you see: "This file came from another computer and might be blocked...", check Unblock.

    • Click Apply, then OK.

  6. Open vBase_Excel_Stamper.xlsm in Excel.

  7. When prompted, enable macros.

Getting Started

  1. Fill in the Stamping Parameters table on the vBase Setup sheet.

  2. Run the vBase functions listed in the vBase Setup worksheet to generate new stamped data.

  3. Stamp a range of cells using one of the following methods:

    • Function Method:

      =StampRangeDataDefault(Range)

      Example:

      =StampRangeDataDefault(C20:D22)
    • Keyboard Shortcut: Press Ctrl + Shift + S to stamp the selected range via the StampRange macro.

Note: Stamps are assigned to a Collection based on the Collection Name specified in the Stamping Parameters.

  1. You're now ready to start creating verifiable data!

Verifying Your Stamps and Collections

Stamps

To verify that your Excel data has been stamped:

  1. Locate the relevant stamped file on your system.

Collections

To create a verifiable collection:

  1. Zip all the stamped files in the relevant collection directory. (Exclude system files like desktop.ini.)

  2. Verify the collection by loading the zipped file to:

Last updated