Re: Open Excel and pass values to cells

chhaya singh — Wed, 04 Nov 2009 13:27:32 GMT

I don't know how u can pass values from infopath to excel column, but you can attach you excel sheet as an attachment to your form - using file attachment control.

Open Excel and pass values to cells

bradb — Tue, 03 Nov 2009 20:15:48 GMT

I'm posting in the General section because I'm not quite sure where this should go.

I also did a search and didn't come up with a definitive answer. Hopefully someone can help me here!

Here's the scenario:

I have a Infopath Form that is filled out in relation to a piece of equipment. Each piece of equipment also has an Excel datasheet (they all sit in a document library) that's associated with that piece of equipment. The association is done by the user so it's not coded. My plan was to allow them to select the document from a drop down, once selected it opens. I want to pass the critical information from fields in the Infopath form to specific cells in the Excel sheet that it opens. IE. my:equipmentType gets added to cell C9 in the Excel sheet.

That's the first part. If it was possible to then save the sheet as an attachment to the Infopath report it would be even better. THe user also has to make a couple changes within the Excel sheet before it's saved.

Does anyone have any idea how to do this or where I can read up on how to do it?

Thanks!