Is there a way to link an infopath field to an excel cell?

[notyelf]

See subject?

I am having too much difficulties getting math to work right on dates (for
example I have a date field that I use, then in another field I do that field
+ 3 and end up with Nan). Basically I want to create a table that mirrors the
excel sheet, so all I have to do is update the excel sheet. Is that possible?

 

[Greg Collins]

Excel allows you to save your form as an XML document, which you can then
use as a source for your form template.

You can also write code do directly manipulate an Excel document (an example
of which you can likely find on the internet somewhere).

 

[Clay Fox]

If you are having trouble with the date calculations it is understandable.
This is not as robust as Excel, however it can be done. If you search for
DateDiff on http://www.infopathdev.com you can find several posts with code
on how to calculate a date three days in advanced or whatever.

One solution is to put your information in a data base and then both
InfoPath and Excel can access and share this information. that way the
InfoPath form could display what was created in Excel.

Greg's suggestion on saving to Xml works but it is a bit more cumbersome if
updating frequently.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Clay Fox]

If you are having trouble with the date calculations it is understandable.
This is not as robust as Excel, however it can be done. If you search for
DateDiff on http://www.infopathdev.com you can find several posts with code
on how to calculate a date three days in advanced or whatever.

One solution is to put your information in a data base and then both
InfoPath and Excel can access and share this information. that way the
InfoPath form could display what was created in Excel.

Greg's suggestion on saving to Xml works but it is a bit more cumbersome if
updating frequently.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com