Hiya i want to open pdf via VB.
i have the code were i can open certin files if i use this code :
Private Sub Command2_Click()
RetVal = Shell("C:Program FilesAdobeAcrobat 7.0ReaderAcroRd32.exe d:Till Manuals120.pdf", vbMaximizedFocus)
But what i want to do is not have to type the location of the file in but for the code to pick it up from a txt box were the location is got from a database