recently, Charles helped me develop some code (thx, Charles) which, when I ran it on my machine, executed all the code perfectly. Now I find that when I run the same code on my girlfriend's machine, I get the error.
Both of the workbooks are in the root directory of my USB thumb drive and both workbooks are open when running the code - works on my machine but not on hers.
We both have Win 7 Ultimate and Excel 2010 on our machines. We both have the same add-ins running in Excel and I even reassigned the driver letter on her machine to "S" so that it matched mine at home but still, no luck.
I'm at a loss as to what might be causing it and wondered if anyone had any ideas?
I've included the code below for perusal - when it brings up the error on her machine the code stops ar the line I've highlighted in red.
Thanks in advance for any suggestions.
Please Login or Register to view this content.