Based on the name of the activity being List rows present in a table, I assume you are trying to build a Power Automate cloud flow, and not a desktop flow (meaning you're in the wrong forum).
Unfortunately, the Excel online connector for Power Automate does not support macro-enabled files. The only options that you have for this are:
a) Run a desktop flow to read the file
b) Use an office script to read the file
Option a) can be quite a feat to establish if you are not already using desktop flows, because that requires a more expensive license, as well as a machine to run the flow on.
Using office scripts is thus likely a better idea. See here for some references on how to do it: https://learn.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/
