How to read range from macro enabled excel file

help on how to read cell range from an open macro enabled excel file. my workflow does not capture the data after running the macro.