gringo287
11-15-2012, 10:11 AM
Hi
The title pretty much covers it i think. Im going to have a data base of pdf url's or file paths of pdf's stored on a local drive (this is dependant on what can or can not be done) Ive sussed how to show a pdf from a userform reader, but i want to adapt the vba to allow for the url/file path to be searched from the cell where they will end up from the users selection.
This works
Private Sub Cmdpdf_Click()
Me.AcroPDF1.src = "http://downloadcenter.samsung.com/content/EM/201110/20111027182521314/GT-I9100_QSG_Orange_Eng_Rev.1.1_111013_Screen.pdf"
End Sub
this doesnt...
Private Sub Cmdpdf_Click()
Application.ScreenUpdating = False
With ThisWorkbook.Sheets("Sheet1")
Dim x As Integer
x = .Range("V28")
Me.AcroPDF1.src = ("x")
End With
End Sub
The title pretty much covers it i think. Im going to have a data base of pdf url's or file paths of pdf's stored on a local drive (this is dependant on what can or can not be done) Ive sussed how to show a pdf from a userform reader, but i want to adapt the vba to allow for the url/file path to be searched from the cell where they will end up from the users selection.
This works
Private Sub Cmdpdf_Click()
Me.AcroPDF1.src = "http://downloadcenter.samsung.com/content/EM/201110/20111027182521314/GT-I9100_QSG_Orange_Eng_Rev.1.1_111013_Screen.pdf"
End Sub
this doesnt...
Private Sub Cmdpdf_Click()
Application.ScreenUpdating = False
With ThisWorkbook.Sheets("Sheet1")
Dim x As Integer
x = .Range("V28")
Me.AcroPDF1.src = ("x")
End With
End Sub