Location of dll (API-function call)
 

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

Location of dll (API-function call)
 

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

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=50622

Location of dll (API-function call)
 

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"
schreef in bericht
...

Hello Jos,

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

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=506223

Location of dll (API-function call)
 

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
ToolsReferences... and then click the BROWSE button. Open your folder,
select the DLL and click OPEN and then click OK.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=506223

Location of dll (API-function call)
 

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

"Leith Ross" wrote
in message ...

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
ToolsReferences... and then click the BROWSE button. Open your folder,
select the DLL and click OPEN and then click OK.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=506223

Location of dll (API-function call)
 

Oops - omit the "/s" switch

Regards,
Peter T


"Peter T" <peter_t@discussions wrote in message
...
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

"Leith Ross"
wrote
in message ...

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
ToolsReferences... and then click the BROWSE button. Open your folder,
select the DLL and click OPEN and then click OK.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread:
http://www.excelforum.com/showthread...hreadid=506223

Location of dll (API-function call)
 

Hi everyone,

thank you very much for your support!

Jos

"Jos Vens" schreef in bericht
...
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