Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Export rows in Excel to lutiple Word files

I have an excel (or access if easier) doc that contains rows of data.
I would like to create a separate word doc from each row.

The clomuns are subject,number,info

I would love the title of each to be "<Number-<Subject" with the
content of the doc itself made up from the Info row.

Is there a way to do this - I know a bit of perl but was hoping for an
easy solution.......

  #2   Report Post  
Posted to microsoft.public.excel.misc
Peter Ellis
 
Posts: n/a
Default Export rows in Excel to lutiple Word files

Try this.

Select the row
Copy to the clip board
Switch to MS Word
Use either Paste to paste the clipboard contents as a table or Paste Special
with the Link Option selected. Perhaps specify as an Excel Worksheet Object.

With many rows this could get tedious but I will get you what you want.








" wrote:

I have an excel (or access if easier) doc that contains rows of data.
I would like to create a separate word doc from each row.

The clomuns are subject,number,info

I would love the title of each to be "<Number-<Subject" with the
content of the doc itself made up from the Info row.

Is there a way to do this - I know a bit of perl but was hoping for an
easy solution.......


  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Export rows in Excel to lutiple Word files

Uh, I was hoping for something a wee bit automated.

  #4   Report Post  
Posted to microsoft.public.excel.misc
Jay
 
Posts: n/a
Default Export rows in Excel to lutiple Word files

I have an excel (or access if easier) doc that contains rows of data.
I would like to create a separate word doc from each row. ...


One approach is Word's "Mail Merge" feature.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing word files to excel files charlie'smom Excel Discussion (Misc queries) 2 August 12th 05 02:28 PM
How do you export MathType from Word into Excel and be able to so. [email protected] Excel Worksheet Functions 1 July 25th 05 07:21 PM
Can Excel Export Data to Word Format? Reddiance Excel Discussion (Misc queries) 2 April 18th 05 06:03 PM
Illegal operation error while printing EXCEL or WORD Files NathanRS Excel Discussion (Misc queries) 0 January 20th 05 02:23 PM
How to I create a pdf file from Word or Excel files stolitx Excel Discussion (Misc queries) 4 December 28th 04 07:17 PM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"