VBA Export of Module Working inconsistently on different computers

I'm having an issue where I have some VBA that exports a module to a file and then later imports it to another file. This works perfectly on my computer and some of my colleagues, but doesn't on certain others' computers. I've tried a couple different things, such as creating a text file in that same folder and that all works, so its not a directory access issue. I also tried writing the name of the module to the text file - works on my computer, not on theirs. So somehow, I suspect the code doesn't read the module in the excel file on their end, but not sure why this would be happening. Any help/advice greatly appreciated!

Please Login or Register  to view this content.

Originally Posted by rorya

What exactly does "doesn't work" mean? Do they have the option to trust access to the VBA Project set in the trust center? If not, your code will never work.

Yup, this was it, thanks! Never got a pop up about it because I had on "on error resume next" .

Okay, solved, thank you!