View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel Programming Question - VBA + WMI

I haven't use WMI, but it isn't native to vbscript I assume. You use
something like

Set objSWbemServices = GetObject("winmgmts:")

I would imagine.


this should work directly in Excel VBA as well.

Or create a reference to it in Tools=References in VBA.

I don't see a problem.

--
Regards,
Tom Ogilvy


"Jim Gregg" wrote in message
oups.com...
Very nice. THank you for the quick results. Just one question regarding
the section on vbscript/wmi. You stated that I could just move my
vbscript to excel. I guess what I was unsure of was whether or not WMI
or ADSI commands would be recognized from within Excel. I have used
external vbscript before to interact with Excel, but I have never
initiated the code from within an excel module.