Solved: show pdf from userform pdf reader based on "file.pdf" from cell reference

[gringo287]

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

[gringo287]

#DOH!!#

this works fine

Private Sub Cmdpdf_Click()
Application.ScreenUpdating = False
With ThisWorkbook.Sheets("Sheet1")
Dim x As String
x = .Range("V28")
Me.AcroPDF1.src = (x)
End With
End Sub