Solved: Inte problems under MSOffice 2010

[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

[Aflatoon]

It appears your form does not have a control named Inet1 - it may be that it was removed when you opened the workbook in 2010. Is your copy of Office 2010 also 64bit?

[tcourl]

It appears your form does not have a control named Inet1 - it may be that it was removed when you opened the workbook in 2010. Is your copy of Office 2010 also 64bit?

Yes, it's a 64-bit MSOffice.

How can I check that the problem is indeed the control missing? And if so, how can I add it back?
(disclaimer: I didn't code this macro - I'm a newbie to VBA) :dunno

Thx

[Bob Phillips]

Lots of controls just don't work in the 64-bit environment. It seems that MSINET.OCX is one of them.

[tcourl]

Lots of controls just don't work in the 64-bit environment. It seems that MSINET.OCX is one of them.

Wow, now I'm getting worried (I have to get this macro running).

What would be the alternative (and still be backward compatible)?

thx!

[Aflatoon]

Switch to 32bit Office if you can (even Microsoft do not recommend using 64bit unless you have a need to work with very large files), or try and find a third party control that is 64bit compatible.

[tcourl]

Ok, I installed now MS Office 32 bit: same error.

Any other idea?

Thx

:banghead:

[Aflatoon]

Do you have a copy of the original workbook that you haven't opened in 2010 previously, just to ensure that control has not been removed?

[Aflatoon]

In fact, some further research indicates that this may perhaps be a Windows issue - see this thread (http://www.vbforums.com/showthread.php?t=599517) for example.

[tcourl]

Thanks

I hope it's not the Windows issue as it seems fairly complex to solve.

I have indeed re-used the original version (ie not yet opened in MSO2010).

Newbie question that might help to solve the issue: how can I re-add the Inet control on the UserForm? (I understand that there should be a component view in VB but can't find it in VBA Excell)

Thanks!

[Aflatoon]

Set a reference to the internet controls then, with the userform selected in design mode, click the Additional Controls... button on the toolbox and locate the internet control.

[tcourl]

Thanks, that solved it!

What a waste of time for such a newbie problem...