lifeson
12-06-2007, 03:32 AM
Hi all
I have a project which lists filters a list of components (boilers)
A user can select a component and oprn a second user form to show specific detail about the boiler.
I want to be able to add the ability for a lsit box to display various documents (which can be .pdf or .doc etc) relating to that specific boiler in a list box, if the user selects one from the list, the doc will open in the correct application.
I this possible?/
I have the docs stored in a file structure based on the make and model of the boiler and have this to determine the correct file path
Dim fPathDocs As String
fPathDocs = ThisWorkbook.path & "\Documents\" & sman & "\" & sModel & "\.*"
With lstDocs
.AddItem 'just document name required????
End With
Tanks for looking, hope you can help
I have a project which lists filters a list of components (boilers)
A user can select a component and oprn a second user form to show specific detail about the boiler.
I want to be able to add the ability for a lsit box to display various documents (which can be .pdf or .doc etc) relating to that specific boiler in a list box, if the user selects one from the list, the doc will open in the correct application.
I this possible?/
I have the docs stored in a file structure based on the make and model of the boiler and have this to determine the correct file path
Dim fPathDocs As String
fPathDocs = ThisWorkbook.path & "\Documents\" & sman & "\" & sModel & "\.*"
With lstDocs
.AddItem 'just document name required????
End With
Tanks for looking, hope you can help