wilmott.com

Hi AllI am trying to get the location of a standard DLL I created in Delphi 6.To get location of a com server is OK.if I use the paramstr(0) it returns the host Excel.exe path. This DLL is an addin for excel.The reason for this is that I want to place the DLL in any location with its accompanied DBtable directory. When DLL loads it must pick up the DBtable directory in the same location as the DLL, to make it robust.Any advise.Thanks.

Have a look at the type library component and registry manipulation component on the VB site under VB6. They are com components but should help you out.Look up the object in the registry and find its loction from there.