Hi

I'm working in Excel and have done something in Visual Basic so that when a change or something is entered in a particular column I want an InfoPath Form to open.

It there a method similar to the

Workbooks.Open (Filepath name) that would work for an InfoPath form, I can get this to work to open an existing Excel spreadsheet, but not to open an InfoPath form.


The other way I was trying to achieve the same result was by having a hyperlink to the InfoPath form in my spreadsheet and then creating a macro to access the Hyperlink and then in the vb script having "Call Macro1"

This worked if I used INSERT - HYPERLINK and browsed to the InfoPath form which results in a link like:
..\annualleave.xsn

But if I used INSERT - FUNCTION - HYPERLINK so I could have the full filename path like:
\\troy\org\timesheets current\annualleave.xsn

And I need it to use the second option (with the full filename path) as the timesheet / spreadsheet could sit in a number of various file locations.

Hope this doesn't sound too confusing.

Any help would be greatly appreciated.

Thanks,


Melissa