I have forms in microsft infopath and currently I want to see if any filed in the path is filled or not and need to maintain in Excel. There are 250 microsoft infopath files need to processed. Please help if I can write any code or any inbuilt functions can be used to see if any filed is filled or not.
SOLUTION :
SOLUTION :
InfoPath forms internally getting maintained as XML. You may use following procedure for your requirement.
1) Put all InfoPath Xmls in a folder.
2) Using VB Script Iterate thru each file by for each loop, read the xml and get the value for required field as substring.
3) Also based on the field value or required condition, you can write extracted substring into the excel.
Hello, my name is Monikandan. I'm a 40 year old self-employed ML Group from the Nagercoil.
No comments:
Post a Comment