Dear friends
I´m a intermediate programmer using VEE Pro 6.01 at many years. I generate programs that interfaces with Excel (97). But today I would like to migrate to a newer version of Excel, like 2007.
I´ve created my own Excel Library that is called at program start, like Agilent Vee newer versions trying to solve an version fault. My libray works very well.
I only changed Excel version (97 to 2007) and after this an error 554 ("<name> is not a member of the referenced ActiveX object") appears.
What happen : Excel 2007 is called and open it but don´t load archive that has been selected and generate an error described above. Normal mode is Excel loading an archive and saving it after I give another name to keep original data intact.
I´m believing that problem is installed on structure I´ve attached to clarify my inquiry. I suppose that I will need to work with "xlib" statements but I don´t know best choice.
If somebody can help me I will be thankful !
Best regards
Leandro
I´m a intermediate programmer using VEE Pro 6.01 at many years. I generate programs that interfaces with Excel (97). But today I would like to migrate to a newer version of Excel, like 2007.
I´ve created my own Excel Library that is called at program start, like Agilent Vee newer versions trying to solve an version fault. My libray works very well.
I only changed Excel version (97 to 2007) and after this an error 554 ("<name> is not a member of the referenced ActiveX object") appears.
What happen : Excel 2007 is called and open it but don´t load archive that has been selected and generate an error described above. Normal mode is Excel loading an archive and saving it after I give another name to keep original data intact.
I´m believing that problem is installed on structure I´ve attached to clarify my inquiry. I suppose that I will need to work with "xlib" statements but I don´t know best choice.
If somebody can help me I will be thankful !
Best regards
Leandro
I do not have experience in upgrading Excel 97 to 2007 with VEE. From what I read from VRF, during Excel upgrade, sometimes Excel DLL API will change, I am guessing probably this is the reason. Which line is giving the trouble? should not give any trouble as similar code can be found from Microsoft website http://msdn.microsoft.com/en-us/library/bb978780(v=office.12).aspx#Y594.