create individual documents from each excel row

May 10, 2012 at 13:56:58
Specs: Windows 7
I would like to create individual word or pdf documents from each excel row and name each document with data from two cells in each row. The excel spreadsheet contains approximately 5000 rows of data and 6 columns. The title of each newly created document would include a text field and a date field pulled from two cells from each row of the spreadsheet. Any help would be greatly appreciated!

See More: create individual documents from each excel row

Report •

May 10, 2012 at 15:04:49
So you're looking to create 5000 documents, each with a single line of text in it?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

May 14, 2012 at 07:45:08
Thanks for the interest!
Yes - each of the rows contains information for an individual issues management record and one of the cells in each row may contain a large amount of text.
This process is a preparation step for using a natural language processing program to look for common concepts amongst the rows of data that represent individual records.
Thanks again,
JD songster

Report •
Related Solutions

Ask Question