LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 279
Default Early variable type issue

My VBA is Microsoft Visual Basic 6.3, from Excel 2003 (11.6535.6360) SP1
from XP Professional Version 2002 SP3.

I have been convinced to use Option Explicit in VBA.
I have also been convinced to go for early typing. The code below uses
late typing.

I have
Dim IE as Object
Set IE = CreateObject("InternetExplorer.Application")

The Set command changes the type of IE from Object to
Object/WebBrowser2
"Dim IE as WebBrowser2" results in a "Compile error: User-defined type
not defined".

From reading past posts, I think Tools/References... could fix that.

How can I find out where WebBrowser2 comes from?
Is there any Basic code which sets references?
I find Tools/References... a bit opaque.

Ideally, any reference which is not explicitly specified would error.
--
Walter Briscoe
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF AND MATCH data type issue EZ[_2_] Excel Worksheet Functions 2 June 18th 09 05:35 PM
Possible Data Type Issue shelfish Excel Programming 3 May 31st 08 11:18 PM
Variable Issue Mike H. Excel Programming 2 November 26th 07 05:01 PM
Variable type Alan Beban[_2_] Excel Programming 2 September 17th 07 06:13 PM
Type of variable J@Y Excel Programming 3 August 14th 07 04:14 PM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"