Compile error in hidden module: Userform1

[george.itpc]

Hi Boys
I have an error COMPILE ERROR IN HIDDEN MODULE: USERFORM1. I upgraded my PC by buying a new PC and I installed all the programs so I can use these macro files created by an workmate which doesn't work anymore for the company.
The OLD PC had the following configuration:
INTEL CPU
WIN XP SP3
OFFICE 2003 PROFESIONAL
2 MB - RAM

NEW PC
INTEL CPU - i3
WIN 7 32 BYTES
OFFICE 2010 PROFESIONAL
4 MB - RAM
SSD - 128 GB

Please help me out. I am even willing to pay if someone can help me out to sort this issue. (info: [email protected])
Thank you

[JosephP]

I reckon you have a missing reference in one of the files you are loading-probably an add-in. which add-ins do you have installed?

[Andy Pope]

As JosephP suggests you are probably missing an external file.
Another possible problem could be missing control. I'm thinking the calendar control, which is not standard in xl2010.

To further your investigation you need to open the file, goto to VBE (ALT+F11), and use the menu Tools > References. To check for missing references.
You can also use the menu Debug > Compile project. This should highlight the line of code.

You will of course need to know the VBA password in order to open the code project.

[george.itpc]

I have no idea if I installed any add-in. I don't know nothing about macros or VB. I just installed Microsoft Office 2010 Professional plus as a standard installation. I can give u access to my computer if needed.
If you know some add-in I need to add, please help me out to find them on a web, and I can try to install them.
Thank you

[Andy Pope]

did you follow the instructions provided in order to check missing references?

[george.itpc]

Error - EXEL.jpg
this is the error I have.

[Andy Pope]

Yes we understand the error message but that does not help discover exactly what the error is.

Again, did you following the instructions provided to check for missing references?

[george.itpc]

Attachment 272804
this is the error I have.

[george.itpc]

OK.
I need to find the password. I pressed ALT+F11 and now is asking for the password. I will come back as soon I have the password.

[Andy Pope]

yeah, that is just the same image again. It's not providing any information to allow us to help you.

Seeing as you are willing to pay consider using the Commerical service.
http://www.excelforum.com/payments.php

Maybe one of those guys can deal more directly with you, possible even share screens.

[george.itpc]

I am gone try to work it out with you if is ok. Just a bit of patient with me to put all the bits together.
Thank you

[Andy Pope]

Okay, but I will not be online all day. I will check this thread as and when I can.

[george.itpc]

Any time, any help is appreciated.
Thank you again

[george.itpc]

Hi,

I'm having some trouble accessing the VBA code on a password protected excel file.
I've tried this:
http://stackoverflow.com/questions/1...el-vba-project

but when I try to open the file again I get a message asking if i want to try and recover the contents of the file

Thanks