ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   LATE BINDING using Set WordApplication = CreateObject(strApp) (https://www.excelbanter.com/excel-programming/302772-late-binding-using-set-wordapplication-%3D-createobject-strapp.html)

jason

LATE BINDING using Set WordApplication = CreateObject(strApp)
 
if i use late binding and the following line :

Set WordApplication = CreateObject(strApp)

where strApp may be:
strApp = "Word.Application"

QUESTION: How do you find out what these strings are for other
applications e.g MSQuery ???

any help greatly appreciated
Jason

Rob Bovey

LATE BINDING using Set WordApplication = CreateObject(strApp)
 
Hi Jason,

These entries are all located in the Registry under the
HKEY_CLASSES_ROOT hive. As far as I know, MSQuery can't be automated, so you
won't find an entry for it.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"jason" wrote in message
om...
if i use late binding and the following line :

Set WordApplication = CreateObject(strApp)

where strApp may be:
strApp = "Word.Application"

QUESTION: How do you find out what these strings are for other
applications e.g MSQuery ???

any help greatly appreciated
Jason





All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com