wilmott.com

If I have a DLL is it possible to find outs it GUID?

Google "oleview", it's a tool from MSFT. With that tool File | View TypeLib menu option.

You can also goto VS command line and type 'oleview' BTW why do you want GUID which is for the machine? ProgID is the human equivalent. And if the dll is a .NET assembly you can use Reflection API to navigate in all modules.

I was looking at automating the early binding a reference in VBA where I needed the GUID of the DLL.

QuoteOriginally posted by: MaxCohenI was looking at automating the early binding a reference in VBA where I needed the GUID of the DLL.If I have understood, you call DLL function from VBA? Or do you need the GUID in order to access the code?

I don't need to access the code altough that would be useful.It was more a case of being able to add references to the VB project via code and have the reference saved with the project. You add some library/reference/DLL in Excels VBE (Tools->References) e.g. 'Microsoft Scripting Runtime' which is required if you want to early bind the Scripting objectIf you dont add the reference then late binding we have to write (and have no intelli-sense on the object)Dim d As ObjectSet d = CreateObject("Scripting.Dictionary")Add the reference early binding we haveDim d As Scripting.DictionarySet d = New Scripting.Dictionary