Inet problem (stuck for days now...)

[tcourl]

Dear all,

I'm stuck for several days now on the following problem (and I'm desperate!):

I have an Excell 2003 document with a macro (VBA) that runs fine on WinXP 32-bit MSOffice 2003. However I can't get it run on Excell 2010 Win7 64-bit.

The execution stops at the following line:

With UserForm1.Inet1

It highlights the

Inet1

and provides the following error message:

Compile error:
Method or data member not found

So far I have done the following:

• Checked that all references are the same than in Excell 2003 (especially Microsoft Internet Transfer Control)
• Added and registered the MSINET.OCX component using regsvr32 command (in the WINDOWS\SYSWOW64 folder as it didn't work in the WINDOWS\SYSTEM32 folder)

Any help / suggestion would be highly appreciated.

Many thanks !
Cheers,
Thomas

[nO_OnE]

What is the 'Inet1' Referencing in your original project? Is it a textbox or something on your form?

[techgnome]

judging by the name it's an INet control... if it's not begin found, then that means that there is no INet control names INet1 on Form1.

-tg

[tcourl]

Thanks guys

Found a workaround (couldn't get it work in 64bit as MSINET.OCX is not compatible): installed MSOffice 32bit and added the Inet control on the Form.

Cheers

[nO_OnE]

Glad you figured it out, switching between 32 and 64 bit versions of office is quite a pain