Inet problem (stuck for days now...)

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:

Code:

---

With UserForm1.Inet1

---

It highlights the

Code:

---

Inet1

---

and provides the following error message:

Quote:

---

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

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

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

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

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