D
Dave
Hi;
We're converting Outlook forms into InfoPath, and I've run into a problem.
Many forms, to print, use an Excel spreadsheet. VBScript attached to a
button opens the spreadsheet in the background and feeds cells data from the
form.
I can't get this to work with InfoPath. I've been through the msdn stuff
and everything I try gives me an error that "object doesn't support property
or method," or something similar.
This is what I'm trying now - the error I get is "Reference to undeclared
namespace prefix: 'dfs'. The code is: .Cells.Range("F5").Value =
Application.ActiveWindow.XDocument.DOM.selectSingleNode("/dfs:myFields/my:REQBY").text. "REQBY" is the name of the field in the form.
I'd like to keep this scheme of using spreadsheets, since they're already in
place and maintained by the business users (hence, not me!). So just how do
I grab fields out of the form?
Thanks!
We're converting Outlook forms into InfoPath, and I've run into a problem.
Many forms, to print, use an Excel spreadsheet. VBScript attached to a
button opens the spreadsheet in the background and feeds cells data from the
form.
I can't get this to work with InfoPath. I've been through the msdn stuff
and everything I try gives me an error that "object doesn't support property
or method," or something similar.
This is what I'm trying now - the error I get is "Reference to undeclared
namespace prefix: 'dfs'. The code is: .Cells.Range("F5").Value =
Application.ActiveWindow.XDocument.DOM.selectSingleNode("/dfs:myFields/my:REQBY").text. "REQBY" is the name of the field in the form.
I'd like to keep this scheme of using spreadsheets, since they're already in
place and maintained by the business users (hence, not me!). So just how do
I grab fields out of the form?
Thanks!