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
Bookmarks