Design Parameter Macro Runner (VBScript Version)

Overview

Design Parameter Macro Runner is a VBScript utility for automating the execution of Excel macros that extract or manipulate design parameters from spreadsheets. It is especially useful for engineering, architecture, and related fields where parameter extraction from Excel files is common.

This script searches for your design parameter workbook (DesignExtractor.xlsm or variants) in common Windows locations and runs a macro (e.g., GetDesignParameter or alternatives) to process your data.

Features

• Automated Macro Execution: Runs an Excel macro to extract design parameters.
• Flexible File Location: Searches multiple common directories for the workbook.
• Macro Name Detection: Tries several possible macro names and lists available macros if not found.
• Error Handling: Provides clear messages if files or macros are not found.
• Silent Operation: Runs Excel in the background with no pop-ups.
• Windows Compatible: Designed for Windows environments using VBScript.

Getting Started

Prerequisites

• Windows PC with Excel installed.
• The workbook file (DesignExtractor.xlsm or similar) containing the required macro.
• VBScript enabled (default in Windows).
• Necessary folder and macro access permissions.

Installation

1. Clone or download this repository:

   git clone https://github.com/Umar-444/Design-Parameter-Macro-Runner.git
   cd Design-Parameter-Macro-Runner

2. Place the DesignExtractor.xlsm file in one of the following locations for automatic detection:

   • Documents
   • Desktop
   • Downloads
   • Or update the script with your custom file path.

Usage

1. Run the script:

   • Double-click the .vbs file in Windows Explorer, or
   • Run from the command line:

     cscript DesignParameterMacroRunner.vbs

   (Replace DesignParameterMacroRunner.vbs with your script name)

2. What the script does:

   • Finds your Excel workbook.
   • Opens it silently.
   • Attempts to run the GetDesignParameter macro (or similar).
   • Lists available macros if the main one is not found.
   • Saves and closes the workbook.

Customization

• Update File Paths:
  If your workbook is not in a default location, edit the filePath variable in the script to point to the correct folder.
• Macro Name:
  If your macro has a different name, add it to the alternativeMacros array in the script.

Troubleshooting

• File Not Found:
  Ensure the .xlsm file exists in the expected location. Update the script's filePath variable if needed.
• Macro Not Found:
  Make sure the macro exists and is not password protected. The script will print available macros if it can't find the main one.
• Excel Not Installed:
  The script requires Microsoft Excel to be installed.

Contributing

Contributions are welcome! Please follow these steps:

1. Fork the repository.
2. Create your feature branch (git checkout -b feature/AmazingFeature).
3. Commit your changes (git commit -m 'Add some feature').
4. Push to the branch (git push origin feature/AmazingFeature).
5. Open a Pull Request.

See CONTRIBUTING.md for more details.

Issues & Support

If you encounter any issues, please report them here.

License

This project is licensed under the terms of the MIT License.

Contact

For questions or feedback, open an issue or contact Umar-444.Umar-444.

---

Automate your design parameter extraction with ease!