Automation scripts

• Merge every Excel file in a folder into one sheet (VBA)

  A single macro that stacks the first sheet of each workbook in a folder into one master sheet, tagging every row with its source file.

  • VBA
  • Excel
  • Automation
  • Beginner

• Log serial port data to CSV with Python

  Read lines from an Arduino, sensor or lab instrument over a serial port and save each one with a timestamp, ready for Excel or pandas.

  • Python
  • Serial / hardware
  • Automation
  • Intermediate