Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
security officers location status time call in forms | Setting up and Configuration of Excel | |||
How to call a macro at another location | Excel Discussion (Misc queries) | |||
How to call up a macro in a different location? | Excel Discussion (Misc queries) | |||
Excel: Use pic location string to call up picuture in cell? | Excel Discussion (Misc queries) | |||
call a function from VBA | Excel Programming |