VBA Compiler error- Excel 2010

[kt090678]

Hello Forum members,

I need some help, I have a macro which pulls data from one of the website and saves links in the excel sheet.

When I was using Windows XP and Excel 2007 it was working fine, however when I moved to Windows 7 and Excel 2010 it is not working.

earlier the file was protected and I was getting compiler error however when I have un protected this and tried running it now I get user defined function error

Can someone look into it and help me out

Thanks

[TMS]

Your VBA Project is password protected so it is not possible to check the details. However, the (first) error highlighted is on the line:

Please Login or Register  to view this content.

Have a look in Tools | References for MISSING references. Uncheck it/them and find the equivalent in your new version of software.



Regards, TMS

[kt090678]

Hi,

Tahnk you for your response, I have un checked the missing references however I am not sure how do i select the approriate one for this

also I am attaching the unlocked version for your reference

[TMS]

You need to use Tools | References and search for and select the equivalent reference.

The Project can be viewed but it is still locked. It would be easier if I could view the original "broken" version so I could see what the reference is that you have unchecked.

[romperstomper]

MODI is Microsoft Office Document Imaging, which was removed in 2010 - but you can reinstall it: http://support.microsoft.com/kb/982760

[TMS]

Thanks RS. Couldn't find it in 2007 either.


Regards, TMS