I have a C++ application that communicates with Excel via OLE. One of the things it can do is to send Excel 4-style macros to Excel. This macro language is old, but still works for me. Unfortunately, I have a user who is having trouble with some of the macros being sent. When I send the macro SAVE.AS("myfile.xls") it executes correctly. However, when I try to call a VBA function that is in the workbook using RUN("ThisWorkbook.VBAFunction",false) it does not work. I've tried this on several computers with (apparently) identical hardware, software and Excel settings, but there is a single computer where it just doesn't work. (Most of the computers that I'm trying it on are using Windows XP SP2 with Excel 2007.)
Is there anyone out there that has experience with this sort of Excel communication that could give a me push in the right direction? Thanks in advance.