Greetings:
I have Excel 2000 on my work pc. I've written some macros using the sendkeys command to control a mainframe application. A co-worker has Excel 2003. She seems to have a lot of trouble getting the macros to work on her pc. The macro is not too fancy - it just reads the data in the Excel file, send the keystrokes to the mainframe, and write back return messages. Is this an expected result in trying to convert to a different version? Is there a good source of what I would need to do to convert macros for different versions?
Thank you in advance.
David
I have Excel 2000 on my work pc. I've written some macros using the sendkeys command to control a mainframe application. A co-worker has Excel 2003. She seems to have a lot of trouble getting the macros to work on her pc. The macro is not too fancy - it just reads the data in the Excel file, send the keystrokes to the mainframe, and write back return messages. Is this an expected result in trying to convert to a different version? Is there a good source of what I would need to do to convert macros for different versions?
Thank you in advance.
David