Location of dll (API-function call)

[Jos Vens]

Hi,

can anyone tell me where the standard directory is where Excel finds
dll-files that can be called in an API-function call?

In order to make PDF-files, I read this text:

"You will need to place the Ghostscript DLL where it can be found
by Visual Basic."

Is it also possible to put the dll-file in another folder and tell excel
where it is located?

Thanks
Jos Vens

 

[Leith Ross]

Hello Jos

Have you tried looking in the SYSTEM folder on your hard drive? Thi
were about 95% of all DLLs are kept

Sincerely
Leith Ros

 

[Jos Vens]

Thanks Leith,

it works!

Can you tell me if I can put it in another location so Excel still can find
it (a folder where I want to put it eg. D:\MyProgramFolder\).

Jos Vens


"Leith Ross" <[email protected]>
schreef in bericht
news:[email protected]...

 

[Leith Ross]

Hi Jos,

You can. Move the DLL to the new directory (folder). You'll need to add
a reference in VBA to the file. Open the VBA editor, go to
Tools>References... and then click the BROWSE button. Open your folder,
select the DLL and click OPEN and then click OK.

Sincerely,
Leith Ross

 

[Peter T]

If moving a dll first un-register then re-register

Windows/Start > Run
Regsvr32 /s oldDLLfullname /u
Regsvr32 /s newDLLfullname

But suggest DON'T move any dll's containing API functions, or any other
system dll's

Regards,
Peter T

 

[Peter T]

Oops - omit the "/s" switch

Regards,
Peter T

If moving a dll first un-register then re-register

Windows/Start > Run
Regsvr32 /s oldDLLfullname /u
Regsvr32 /s newDLLfullname

But suggest DON'T move any dll's containing API functions, or any other
system dll's

Regards,
Peter T

in message news:[email protected]...

 

[Jos Vens]

Hi everyone,

thank you very much for your support!

Jos