Welcome to the Make community!
Macros can only be run when the file is open on the computer.
Make doesn’t open up excel files, so you cannot run the macros.
An alternative is to use Google Sheets, and you can trigger Google Apps Scripts to run on the Sheets document.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!