Skip to Content
0
Feb 26, 2015 at 09:54 AM

Different VBE error in two different version of Excel

43 Views

Hi experts!!

I have a issue with one client because when they run the reports in their computers,Excel shows a error in VBE. I worked in Excel 2013 and the client have other versión (Excel 2007 or Excel 2010). The issue occurs when one macro run in their computers, if I run the reports and macros in my computer all its ok.

Excel shows different VBE errors. I tried to lock potencial errors and I only could see one difference, its that we have different version of libraries in VBE. is it may be the fault??. The computers where all runs ok has libraries 15.0 but the computer of client has Microsoft Excel 12.0 Object Library and Microsoft Office 15.0 Object Library.

The macro stop in different points. For example:

Page=Activesheet.Name

(This picture is the references availables in my computer)

What can happen? Any input or idea its good received!

This is the diferent errors:


Other time the error was this: Error run time 32809 but I read a discussion in SCN but when I erase the MSforms.exd it didn't solve the problem.

The discussion is: http://scn.sap.com/thread/3699920

The EPM that I use is 10.0 SP 19 and the client has installed the new 20 versión.

Thanks for the support!

Regards,

Jose Blesa

Attachments

librerias.jpg (46.2 kB)
error time da.jpg (18.6 kB)
error falomir.jpg (44.4 kB)