Project: Report Manager

Compatibility Script for Excel Templates

File > Settings > Change > Export - Microsoft Excel

The compatibility script allows a continued use of already existing Excel templates to VBS scripts. These VBS scripts can then be used instead of the previously used Excel templates.

 

Current data transfer technology

The Report Manager creates an Excel file and transfers the previously selected attributes to it. The Excel file obtains a name that is derived from the name of the drawing. After this, the HiCAD Report Manager starts a Visual Basic script, which obtains the newly created Excel path as parameter. The script is to be created by an administrator! This method enables an adjustment of the Excel export to customer-specific requirements.

The ISD has predefined various, industry-specific VBS scripts. After installation, these can be found in the HiCAD directory printdat.

If the HiCAD Report Manager is called with the correct configuration (RMS file), the matching script will be called automatically, and the attribute settings are initialised with the correct values.

For example, if you have selected the configuration HiCAD_Mechanik_01.RMS in HiCAD for BOM creation, the script hicad_mechanik_01.vbs will be automatically preset in the Report Manager for Excel export.

To enable a continued use of existing Excel templates of older versions, you need to use a corresponding compatibility script that is available for all supplied VBS files.

 

Working with the compatibility script

  1. The HiCAD Report Manager creates an Excel file.
  2. The HiCAD Report Manager starts a VBS file (compatibility script) with the file name (1) as parameter.
  3. The VBS file (2) copies an already existing Excel template to a target directory with a name generated from the drawing name.
  4. The VBS file (2) copies the data from the Excel file (1) to the Excel file (3).
  5. The VBS file (2) starts a VBA program (if there is one) that can be part of the Excel template (3).

 

Proceed as follows to use old Excel templates

  1. Copy the already existing Excel template to the PrintDat directory of your HiCAD installation.
  2. In the PrintDat directory, copy the desired Compatibility.....vbsfile (e.g. CompatibilityScript_HiCAD_Mechanik_01.VBS) and rename the copy, e.g. to MeinKompatibilitaetsskript.vbs
  3. Open the file MeinKompatibilitaetsskript.vbs in an Editor and search for the following entries:

  1. For Const Source File, replace the already existing file name (here: HiCAD_DB_Mechanik_01.XLS) with the name of your Excel template.
  2. For Const VBAMacroName , replace the existing macro name (here: DieseArbeitsmappe.Coordinate) with the name of the macro that you want to be executed after starting the Excel template.
  3. If you do not want any macros to be executed, you need to delete the corresponding entry in the code. Search the entry

and delete it.

 

An important prerequisite for a successful start of the Excel template is a continued use of all files that you adjusted in the course of the previous use of BOMs. This includes adjusted HDB, HDX, RMS and XLS files. When you save the changes to the HiCAD Report Manager, a modified RMS file will be created that must then be used.

Settings - Export Microsoft Excel • Settings - View • Column Totals

© Copyright 1994-2020, ISD Software und Systeme GmbH
Version 2502 - Report Manager
Date: 15/10/2020     Language: 1033

> Feedback on this topic

Data protection • Terms and Conditions • Cookies • Contact • Legal notes and Disclaimer