R
ridawg
Hey,
I've read a couple posts on this but still haven't seen anything that
clearly explains how to do this. So here's my situation:
I have form that uses an Access database as a data source. The user comes
in, queries the database and the query returns customer information along
with information regarding their purchases for up to 4 product lines. The
data area of the form is made up of a repeating section that has 5 tables:
1 layout table that contains general customer info (name, account rep, etc.)
4 repeating tables - one for each product line (the customer has to have
data related to one of our products to be in the database so at least 1 table
will have data and up to all 4 could have data).
I would like to create a button that allows the user to export the data to
Excel. I would like to create a spreadsheet for each product line so if data
exists for each product line I would have 4 spreadsheets and if data exists
for just 1 product line I have one spreadsheet. On each spreadsheet, along
with the data for the product line I would also like the general Customer
information.
My understanding is that the InfoPath export to Excel is limited so I would
need to write some code. I just need an idea of what steps I need to do. Do I
start in Excel by creating an XML Map and creating an Excel template then
write vbscript for a button I put in InfoPath? Just looking for some clear
direction on the steps I need to do and example code would be great or links
to additional resources would be welcomed!
Thanks!
I've read a couple posts on this but still haven't seen anything that
clearly explains how to do this. So here's my situation:
I have form that uses an Access database as a data source. The user comes
in, queries the database and the query returns customer information along
with information regarding their purchases for up to 4 product lines. The
data area of the form is made up of a repeating section that has 5 tables:
1 layout table that contains general customer info (name, account rep, etc.)
4 repeating tables - one for each product line (the customer has to have
data related to one of our products to be in the database so at least 1 table
will have data and up to all 4 could have data).
I would like to create a button that allows the user to export the data to
Excel. I would like to create a spreadsheet for each product line so if data
exists for each product line I would have 4 spreadsheets and if data exists
for just 1 product line I have one spreadsheet. On each spreadsheet, along
with the data for the product line I would also like the general Customer
information.
My understanding is that the InfoPath export to Excel is limited so I would
need to write some code. I just need an idea of what steps I need to do. Do I
start in Excel by creating an XML Map and creating an Excel template then
write vbscript for a button I put in InfoPath? Just looking for some clear
direction on the steps I need to do and example code would be great or links
to additional resources would be welcomed!
Thanks!