GetOpenIEByTitle move from 2003 to 2013

[pjwhitfield]

Morning all,

I have an app that uses the above functionality to pull from webpages.

All was working well until we moved out infrastructure from XP and Office 2003 to Win7 and 2013.

Now the above apps give me an error on the line

Set isSA = GetOpenIEByTitle("TDC083B", False)

Ive had to go in and readd the References for "Microsoft Internet Controls" and "Microsoft HTML Object Library" which got me past errors on the following lines but now it throwing the above and Im a little lost.

Dim isSA As SHDocVw.InternetExplorer
Dim HTMLSa As HTMLDocument

No doubt its just something stupid Im missing but its causing a few problems.

[:) Sixthsense :)]

It is not an environment problem

When you use early binding then you have to enable/establish the References to make it work

[pjwhitfield]

Ive enabled the ones that it used without problem previously ie "Microsoft Internet Controls" and "Microsoft HTML Object Library" which gets past the Reference errors when declaring the variables but I still hit the problem Ive detailed.

[Norie]

Can you post the code for the GetOpenIEByTitle sub/function?

Also, can you tell us what the error message is?

[pjwhitfield]

Can you post the code for the GetOpenIEByTitle sub/function?

Also, can you tell us what the error message is?

aaaaaand there it is! My foolish moment of the day, id checked through all the code in the sheet and there is no function called GetOpenIEByTitle so I (foolishly) assume its an existing Function rather than UDF............Id googled and there were loads of results for that function so it all tied in....

no, the function was a UDF from the net that seems to be widely used and somehow it (and many more) had been removed from this worksheet.

</EmbarassedFace>

Thanks for the efforts folks.