[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2729
  • Last Modified:

VBA error: Cannot create Inet1 object?

Running the macro below in PowerPoint 2002 produces the error:

Error 429: "Activex component cannot create object"

on this line: Set Inet1 = CreateObject("InetCtls.Inet")

I have referenced Microsoft Internet Controls (tools > references > ).

Could someone please suggest possible corrections?

Please be aware that I am a total VBA newbie trying to build this by copying examples.

Sub WebUpdate()

    Dim Inet1 As Object
    Set Inet1 = CreateObject("InetCtls.Inet")
    Dim txtURLSource As String
    txtURLSource = Inet1.OpenUrl("http://www.mydomain.com/a_file.htm")

-- do some stuff with the data here --

End Sub
0
xfvgdrthbdtyvhgscv
Asked:
xfvgdrthbdtyvhgscv
1 Solution
 
Anthony PerkinsCommented:
Change:
Set Inet1 = CreateObject("InetCtls.Inet")
To:
Set Inet1 = CreateObject("InetCtlsObjects.Inet")
0
 
xfvgdrthbdtyvhgscvAuthor Commented:
Thanks for the suggestion, ac, but still get the same error on that line.  

I'm open to other suggestions if you have them!

0
 
unknown_routineCommented:
the syntax your using is correct.

I  don't see any problem in your code. I tested it on powerpoint 2000 worked fine.


I may be a powerpoint 2002 issue(very unlikely)

As the 1st step  do these things:


1: if you have word2000 or power point 2000 copy paste your code there to see if it works.

2: if you have Visual basic , test your code inside VB to see if it works.

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
zzzzzoocCommented:
You might not have the class registered (or correctly registered) for use in CreateObject.

Open up Regedit (Start -> Run -> "regedit" (press enter)) and check for...

HKEY_CLASSES_ROOT\InetCtls.Inet

It should have subkeys of CLSID and CurVer. The CLSID for me is "{48E59293-9880-11CF-9754-00AA00C00908}" and the CurVer is "InetCtls.Inet.1" which is another key in HKEY_CLASSES_ROOT that may have to exist (not sure).
0
 
xfvgdrthbdtyvhgscvAuthor Commented:
Thanks again.

My objective here is to get some data from a cgi-script and update a chart in a slide.  I have another macro that opens an IE window and calls the script.  I could have the script output the needed data in form elements or javascript variables that I can then access fromVB.  But I had wanted to avoid this just for the sake of elegance.

Frankly, though, the more I read about using Inet, the less I'm tempted by elegance.  I see tons of potential pitfalls for my code to fail, considering that the final PPT file is intended to be downloaded by any of a thousand users whose PC's and their installed Office might have any number of configurations.

So I'm increasingly leaning today towards the IE window solution.

Anyone care to contradict / confirm this plan?

Thanks again.
0
 
moduloCommented:
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now