Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi al..
I have a problem.. I placed the question here last week aswell, unfortunatly it did not solve my problem.. Scope: I have a userform where I would like to add some buttons wich open certain adobe PDF files. Furthermore, this project is to be burned on a CD so it can be distributed. My problem are the drive letters.. (diffrent systems, diffrent drive letters..) this is the code i'm using.. _______________ Private Sub CommandButton19_Click() 'open pdf file Dim filelocation As String filelocation = ThisWorkbook.Path _________________ I'm missing the last part where I call the variable filelocation and open the pdf file.. Who can help me out? -- Arjan Bregman ***** the knowledge is always there, maybe hidden, but it is there.. ***** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
Specify Path / open all files in folder... | Excel Programming | |||
Dynamic directory path | Excel Discussion (Misc queries) | |||
setting a dynamic path in an excel query | Excel Programming | |||
Making path of linked cell dynamic | Excel Discussion (Misc queries) |