Hi, I have a workbook with about 40 modules and forms etc, but it is made in excel 2003. It runs ok in excel 2007, but I get a lot of errors in vba when trying to open in excel 2010.
I checked the references in the vba editor, and I found that I don't have the following refs in excel 2010:
1) Microsoft Excel 11.0 Object Library
2) Microsoft Forms 2.0 Object Library
3) Microsoft Calendar Control 11.0
4) RefEdit
When I try to open it in excel 2010, it says compile error in hidden module and it stops from opening and excel shuts down.
With various tests I have found examples of code that is not recognized, such as date and time, mid, etc.
Can anyone help me because the project is huge and I need to try to convert it to excel 2010. I would be really really greatful if you would have any ideas for my situation.
Thanks in advance, I'm looking forward to your input.
I checked the references in the vba editor, and I found that I don't have the following refs in excel 2010:
1) Microsoft Excel 11.0 Object Library
2) Microsoft Forms 2.0 Object Library
3) Microsoft Calendar Control 11.0
4) RefEdit
When I try to open it in excel 2010, it says compile error in hidden module and it stops from opening and excel shuts down.
With various tests I have found examples of code that is not recognized, such as date and time, mid, etc.
Can anyone help me because the project is huge and I need to try to convert it to excel 2010. I would be really really greatful if you would have any ideas for my situation.
Thanks in advance, I'm looking forward to your input.