1 person found this helpful
GetCurrentMacroPathFolder gets the folder containing the macro that SolidWorks is currently running. In your case, you are running code from Excel and no macro is running in SolidWorks. Therefore, you get Null.
If I understand what you're actually looking for, Ivana has given you the solution.
Thank you both.
It works like a charm.