Am I looking up the wrong tree. Is there a way for a user to use the FileDialog then open the excel workbook they click on. The path is on the server.
Novice
Windows 7 64bit 
Access 2010 64bit
Am I looking up the wrong tree. Is there a way for a user to use the FileDialog then open the excel workbook they click on. The path is on the server.
VIP
Windows 7 64bit Access 2010 32bit
Yes, the selected file path/name can be used with FollowHyperlink.
Or this alternative to FollowHyperlink http://allenbrowne.com/func-GoHyperlink.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Using FileDialog to export to Excel
Open Excel .xlsx file from Access
Posting Permissions
Reply With Quote