Does the form have to be made in Excel?
If not, I would suggest creating the form in Word and use the "reference document guide"(Direct translation from swedish) to read the data from the source Excelfile.
I'm not quite sure what it's called in the English version, might be Mail Merge.
You'll find it under the Tools menu.
That would save you alot of time.
Anyway, I suggest sticking to Excel and VBA as long as it's possible because involving an external application is often not worth it.
If you want to involve another language anyway, I would suggest Visual Basic 6 or VB.NET/C#.
That way you can make use of the CreateObject function and make an instance of the "Excel.Application" COM object to interact with Excel.
If not, I would suggest creating the form in Word and use the "reference document guide"(Direct translation from swedish) to read the data from the source Excelfile.
I'm not quite sure what it's called in the English version, might be Mail Merge.
You'll find it under the Tools menu.
That would save you alot of time.
Anyway, I suggest sticking to Excel and VBA as long as it's possible because involving an external application is often not worth it.
If you want to involve another language anyway, I would suggest Visual Basic 6 or VB.NET/C#.
That way you can make use of the CreateObject function and make an instance of the "Excel.Application" COM object to interact with Excel.