Materials & Downloads

All files and resources for the Excel Macros tutorial in one place.

---

Practice Files

Work through exercises with these files:

File	Description
Tensile_Test_Sample.xlsx	Practice workbook with 7 specimen sheets and XRD samples for Exercise 1 & 2
Exercise_Workbook	Hands-on exercises with step-by-step instructions
Exercise_Workbook.docx	Exercises in Word format (offline reference)

---

Demo Files

Example files used throughout the tutorial:

File	Description
Macro_Examples_Structure_Fixed.xlsx	Demo workbook with sample tensile test data and specimen dimensions
Experiment1.txt	Sample UTM machine output for import demonstrations
Workshop_Macros.bas	Pre-built macros for all tutorial examples (import into VBA Editor)

---

Reference Files

Quick reference and solutions:

VBA Quick Reference

File	Description
VBA_CheatSheet	Quick syntax reference with common operations and examples
VBA_CheatSheet.docx	Cheat sheet in Word format (offline reference)

Exercise Solutions

File	Description
Exercise_Solutions	Complete solutions with detailed explanations for all exercises
Exercise_Solutions.docx	Solutions in Word format (offline reference)
Exercise_Solutions.bas	Working VBA code for all exercises (import into VBA Editor)

---

Code Templates

Ready-to-use macros you can adapt:

File	Description
Create_Toolkit_Panel.bas	Creates professional button panels in Excel worksheets
Import_Tensile_Batch.bas	Batch import multiple .txt files from UTM machines

---

AI Assistant Tools

Use LLMs (ChatGPT, Claude, etc.) to generate advanced macros:

File	Description
excel-vba.rules	Prompt rules for LLMs to generate production-ready VBA code

How to use:

1. Download excel-vba.rules
2. In ChatGPT/Claude, paste the rules file content
3. Ask for VBA macros - the LLM will follow best practices automatically
4. Example prompt: "Create a macro to calculate yield stress from tensile test data in columns A-D"

← Back to Tutorial Overview