╔══════════════════════════════════════════════════════════════════╗
║       FROM EXCEL TO VBA — Exercise File Pack                    ║
║       From Spreadsheets to Code Series — Book 5                 ║
║       Waskey Press  |  www.waskeypress.com                      ║
╚══════════════════════════════════════════════════════════════════╝

FIRST STEP — SAVE EACH FILE AS .xlsm BEFORE YOU START
──────────────────────────────────────────────────────
The starter files are provided as .xlsx to ensure they open on all
versions of Excel (including LTSC). Before working on each chapter:

  1. Open the .xlsx file from the starter/ folder
  2. File → Save As
  3. Change "Save as type" to: Excel Macro-Enabled Workbook (*.xlsm)
  4. Click Save
  5. Press Alt+F11 to open the VBA Editor

This is exactly what Chapter 0 teaches — it is your first exercise.

TRUSTED LOCATION SETUP (one-time)
───────────────────────────────────
File → Options → Trust Center → Trust Center Settings
→ Trusted Locations → Add new location
→ Browse to your vba-course/ folder
→ Tick "Subfolders of this location are also trusted" → OK


FOLDER STRUCTURE
────────────────
starter/             One .xlsx per chapter — open and save as .xlsm first
  ch0_setup.xlsx          Chapter 0  — Setting Up
  ch1_variables.xlsx      Chapter 1  — Variables & Object Model
  ch2_procedures.xlsx     Chapter 2  — Sub, Function, Error Handling
  ch3_conditionals.xlsx   Chapter 3  — If / Select Case
  ch4_loops.xlsx          Chapter 4  — Loops & Arrays
  ch5_workbooks.xlsx      Chapter 5  — Workbooks & File Operations
  ch6_ranges.xlsx         Chapter 6  — Ranges, Find, Sort, AutoFilter
  ch7_tables.xlsx         Chapter 7  — Tables & PivotTables
  ch8_userforms.xlsx      Chapter 8  — UserForms
  ch9_events.xlsx         Chapter 9  — Events
  ch10_report_generator.xlsx   Project 1 — Monthly Report Generator
  ch11_cleaner.xlsx            Project 2 — Data Validation & Cleaner
  ch12_invoice.xlsx            Project 3 — Invoice Generator + PDF

data/                Datasets used throughout the book
  sales_2024_full.xlsx    2,150 orders, full year 2024 (10 columns)
  sales_2024_q1/q2/q3/q4.xlsx  Quarterly files
  products_catalogue.xlsx       15 products
  employees.xlsx                150 employees

monthly_data/        Source files for Project 1 (Report Generator)

solutions/           Available at waskeypress.com/files

VBA_Cheat_Sheet.xlsx 34 VBA patterns with Excel equivalents


THE SALES DATASET (10 columns)
───────────────────────────────
  A date    B customer    C region    D product    E category
  F quantity    G unit_price    H total    I status    J sales_rep


⚠  ALWAYS SAVE WITH MACROS
────────────────────────────
Once you have saved a file as .xlsm and added VBA code:
  → Always save as: File → Save As → Excel Macro-Enabled Workbook (*.xlsm)
  → Never overwrite with .xlsx — Excel will delete all your VBA code


CONTACT
────────
www.waskeypress.com/files  |  contact@waskeypress.com
