Excel spreadsheet to Word document

  • Thread starter Thread starter GWC
  • Start date Start date
G

GWC

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?
 
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?
Click to expand...

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
 
Back
Top