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
[VBA]Private Sub Cmdpdf_Click()
Me.AcroPDF1.src = "http://downloadcenter.samsung.com/co...013_Screen.pdf"
End Sub[/VBA]

this doesnt...
[VBA]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[/VBA]

[gringo287]

#DOH!!#

this works fine

[VBA]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[/VBA]