shi6oonz
06-18-2018, 06:34 AM
Hello All
i am facing a problem and i wish from you to help with it
The Problem :
i have a userform with listbox1 & CommandButton1 and i am using the listbox1 to select file name from Sheet5 > Rowsource "d1:d20" and to open it as pdf
i used this code
If Me.ListBox1.Column(0) = "cie_plant_result_list" Then
ThisWorkbook.FollowHyperlink "C:\Result\cie_plant_result_list.pdf." and it work perfect !
but i am trying to get second file to Listbox1.column(1) for example :
If Me.ListBox1.Column(1) = "edc_plant_result_list" Then
ThisWorkbook.FollowHyperlink "C:\Result\edc_plant_result_list.pdf."
End If
after press the commandbutton1 this error display !
22446
i really appreciate your help
i am facing a problem and i wish from you to help with it
The Problem :
i have a userform with listbox1 & CommandButton1 and i am using the listbox1 to select file name from Sheet5 > Rowsource "d1:d20" and to open it as pdf
i used this code
If Me.ListBox1.Column(0) = "cie_plant_result_list" Then
ThisWorkbook.FollowHyperlink "C:\Result\cie_plant_result_list.pdf." and it work perfect !
but i am trying to get second file to Listbox1.column(1) for example :
If Me.ListBox1.Column(1) = "edc_plant_result_list" Then
ThisWorkbook.FollowHyperlink "C:\Result\edc_plant_result_list.pdf."
End If
after press the commandbutton1 this error display !
22446
i really appreciate your help