I want to open a Excel sheet through Word VBA, paste information from the Word document row wise and save it. I have code for picking up specific information from the Word document but do not know how to open Excel and save it.
I have found a solution in the following site: http://www.exceltip.com/st/Control_Excel_from_Word_using_VBA_in_Microsoft_Excel/463.html
It is giving an error and also I do not know how to add a reference to the Excel library in Word.
Error: Dim xlApp As Excel.Application - Compile Error "User defined type not defined"