InfoPath Dev

I would like to have a button, or some other method, on a form that allows a user to open an Excel file on the shared drive.

Any help would be greatly appreciated.

-Dennis

Hi Dennis and welcome to our forum!
You could add a link to your form with the path to the Excel file. If you need to modify the link, you could set your link to a field and change it as the result of some other change on your form (using rules or code).

Patrick Halstead [InfoPath MVP]
InfoPathDev

Hi Patrick and thank you so very much for replying. I attempted to add the link (through a hyperlink) example: C:\test.xls and it opened up Explorer with an error sying "this page cannot be displayed."

The file is on a shared drive accessable by many.

Again, any help would be greatly appreciated!

-Dennis

Hi again,
What is the path of the file on the shared drive?

Patrick Halstead [InfoPath MVP]
InfoPathDev

K:\DPMA\Intek.xls

Hi again Dennis,
Open up InfoPath in Design mode. Navigate to Controls in the taskpane. Drag a Hyperlink control to your view. The hyperlink properties dialog will appear. Enter k:\dpma\intek.xls in the Link To/Address field. Put a display name in the Display/Text field (for example "Intek Data". Click OK on the dialog and preview the form. You should be able to click on the link and Excel will open.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Hi Patrick,

Same error as above. Seems that Infopath is not recognizing the file as an Excel file?