Use Excel to Generate InfoPath Surveys

[s4miller]

Hello,

I can’t seem to find any threads/materials online to help with the following Excel VBA automation problem and I am looking for some help/direction –

I am currently developing a corrective action tracker in Excel that generates a new Microsoft InfoPath survey for each corrective action in my standardized Excel spreadsheet. I have all of the Excel VBA code and logic required for the tracker except for the code that actually launches the InfoPath application, selects the appropriate InfoPath survey template, copies the corrective action data from Excel and pastes it into the InfoPath survey, and then saves the InfoPath survey as a new InfoPath file.

I have developed several similar custom Excel tools that automate the generation of a series of text, Word, or PowerPoint files but I have never attempted InfoPath. Unfortunately, I am locked into using InfoPath and I can’t seem to find any resources to help with this challenge.

Does anyone know if it is possible to automate the generation of several InfoPath surveys using Excel? Is a custom API required and if so where should I look to learn how to develop a custom API?

Thanks,