How to Run VBA Macro without opening Excel file?

Опубликовано: 06 Октябрь 2024
на канале: OfficeTricks

8,236

111

Learn how to run a VBA macro present in a Excel file without opening it manually.
This technique uses a VBS script method to create instance of Excel application and then run the macro.

To use this method, you don't have to learn VBS script coding.
Get the code from this page: https://officetricks.com/how-schedule...

This code creates an Excel application object, run the file from the path provided and then runs the vba macro code. This way, you don't have to open the Excel file manually from the path. But still, you should know the name of the macro present in the file.

This page also explains how you can schedule this VBS script, so that the macro is run daily without any manual intervention.