Hi,
So I have a batch macro that is supposed to fill a bunch of named ranges inside an Excel template file. Let's say the template is located on my LAN at folder X.
When I run the macro, I get "unable to open file for write" but instead of displaying the correct folder path it is showing my macro folder location instead which is lets say Folder Y.
I can not for the life of me figure out why it is trying to output there, as I am overwriting the ENTIRE FILE PATH with the file path I pass into it from the Macro Input.
Any thoughts on why that would occur? It is driving me nuts.
Thanks
