Our word processing/graphics department creates company forms in LS Designer. I would like to feed spreadsheet data into into a form from VBA. It appears from what I read so far that this is almost impossible for a mere mortal. Is there a format that can be used to populate textfields in the form? I would prefer to drive the process from the spreadsheet since that is where the heavy lifting occurs. If this is not possible for a mere mortal, what is the best (easiest) way to use the form to import data from the spreadsheet (or csv or xml or ....)? Tips, solutions, places to look for more info would be appreciated. I would rather not have to hand enter all the data that I just calculated into a pretty form. Don't know where to search or the right questions to ask to pinpoint a solution.
