Excel spreadsheet to Word document
My Excel spreadsheet has 300 rows and 20 columns.
In each row, Col A contains a job-name and Cols B thru T contain information about various attributes (i.e., date; frequency; input; output; description; etc) of the job-name. How can I convert each row into a Word document with the job-name as the title of the documents and the information in Cols B thru T as paragraphs in that document? |
Excel spreadsheet to Word document
How can I convert each row into a Word document with the job-name as
the title of the documents and the information in Cols B thru T as paragraphs in that document? Read the data into an array and use Join(vDataIn, vbCrLf) to put each row of the array into a new Word doc. If you want a space between paragraphs then just double up on the delimiter... Join(vDataIn, vbCrLf & vbCrLf) -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
All times are GMT +1. The time now is 07:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com