Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
wrote in message
... In reference to my earlier post that includes code to list the processes currently running: You will also need to reference the "Microsoft Forms 2.0 Object Library" from the Visual Basic Editor to get that code to work. Just in case- to do this, open the Visual Basic Editor, then from the main menu select [Tools] then [References] then scroll to locate it and check it. Hope this does the trick for you. Hi. I tried to run this code and obtained the following error message: "Run-time error 432 File name or class name not found during Automation operation" with the Set xWMIService = GetObject("WINMGMTS:{IMPERSONATIONLEVEL=IMPERSONA TE}! \\.\ROOT\CIMV2") line highlighted when I hit Debug. Do you have to check anything in Tools | References to make certain a library available? I tried this, but still got the same error. Wouldn't GetObject be a Windows API call? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
when i open an Excell file 3 workbooks open.Why? | Excel Discussion (Misc queries) | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
List Open Workbooks in VBA | Excel Programming | |||
Workbooks.Open closes other workbooks | Excel Programming | |||
Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming |