Excel / Visual Basic / Open InfoPath Form

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

im not sure what you trying to do im just using the basics but have you tried
Worksheet_Change evebt