PDA

View Full Version : Command Line Open PDF


eversearching35
October 14th, 2008, 05:34 AM
Hello All,

I have built an access database and I want to reference foxit instead of the adobe reader since multiple people will have access to this database.

I ran into a problem with the vba code. Here is what I have:

Private Sub ViewPDF_Click()

Shell ("\\Office\Program\Workgroups\Configuration Management\Database\foxit\foxitreader " & "Office\Program\Workgroups\Configuration Management\Database\PDFs\" & Me.Authority & ".pdf")

End Sub

This works if I remove the space between "Configuration Management" but I can't change the server structure. Can I reference spaces in the file name and location?

Thanks,

Drew

christina
October 14th, 2008, 09:20 PM
Hi Drew, Foxit Reader supports spaces in the filename and location. Maybe something wrong with your usage. I don't know much about the VB, but you can try to add an extra "" to the file path in this example again. Hope this helps.