Cap'n Jack
Final Approach
I have some XL VBA programs that I've used for ~7 years (created in XL '97, opened and saved with XL 2002, 2003, and 2007). They read data from lab instruments, save the data on the active worksheet, and graph it with ~1 second resolution. A co-worker needed to run them on their computer- absolutely wouldn't work. It wouldn't work on 4 other computers, either- just mine. Finally found the problem- my computer has been through 3 XL upgrades, the other computers are fairly new. I had to export the forms and VBA code, create a new workbook in XL 2007, and import the code back into XL. I think XL needed to rebuild the code with current libraries and it worked on my computer because I probably had the older libraries or DLLs someplace. It drove IT nuts too.