[smartcard]

Hello,

I have an Excel sheet that contains data per row. At the end of each row, I want to put a button (or a hyperlink to a file) that will put the data from that row into a new Word document, something like a printer-friendly document.

Please find enclosed the Excel file and the DOC format that I need.

[Rollin_Again]

The easiest way to do this is to create a generic Word "template" file and add form fields to it. Then you can use a button click event in your workbook that will fire some VBA code to transfer the info to your template. Do you want the resulting Word document to be automatically saved with a particular filename to a certain location or will simply displaying it be enough?

What version of MS Office / Excel / Word are you using?

Regards,
Rollin

[Aj_old]

Smartcard, isn't easier to make a new sheet in Excel, in which you'll have the data arranged as you need? This in the case you need this only for printing!

[smartcard]

The easiest way to do this is to create a generic Word "template" file and add form fields to it. Then you can use a button click event in your workbook that will fire some VBA code to transfer the info to your template.

Yes, this is the option I need, but sorry I am not good at VBA codes.

Do you want the resulting Word document to be automatically saved with a particular file name to a certain location or will simply displaying it be enough?

Not very important to save, simply pop up the DOC file while clicking the said button will be sufficient.

What version of MS Office / Excel / Word are you using?

MS Office 2003 SP3

Thanks a lot.

[smartcard]

Originally Posted by Aj_old

Smartcard, isn't easier to make a new sheet in Excel, in which you'll have the data arranged as you need? This in the case you need this only for printing!

No, I don't need new sheet in Excel, I need the Word file to be created using a single row data from the Excel.

[Aj_old]

How many rows of data you can have in the sheet?
What you'll say if will be used only one button, and it will transfer the data from the selected row to Word, or a button to the end of each row is the only way you wanna it be done?

[smartcard]

Originally Posted by Aj_old

How many rows of data you can have in the sheet?
What you'll say if will be used only one button, and it will transfer the data from the selected row to Word, or a button to the end of each row is the only way you wanna it be done?

The sheet will have growing number of row's now it may have 30 but later will will increase even upto 1000

I believe one button approach would be fine.

[Aj_old]

Try the file I uploaded!
Select one cell from the row you need to export to word, and hit the "Export to Word" button!
It will create a new word doc (if word application is not running it will start it) with the data you need in it!

[smartcard]

Originally Posted by Aj_old

Try the file I uploaded!
Select one cell from the row you need to export to word, and hit the "Export to Word" button!
It will create a new word doc (if word application is not running it will start it) with the data you need in it!

This is great, but can we have the data populated to a Word template? meaning I will have Word file with other text etc., and this row data will be inserted in to its positions.

[Aj_old]

Originally Posted by smartcard

This is great, but can we have the data populated to a Word template? meaning I will have Word file with other text etc., and this row data will be inserted in to its positions.

You want data to be added into a word file, which already exist and has some data in it, or just put data into a new word file created on a specific template?

[smartcard]

Originally Posted by Aj_old

You want data to be added into a word file, which already exist and has some data in it, or just put data into a new word file created on a specific template?

I want data to be added into a word file, which already exist and has some data in it.

[Aj_old]

Originally Posted by smartcard

I want data to be added into a word file, which already exist and has some data in it.

Where data should be added? What is the structure of the doc? Name, and so on! Is doc open or excel should open it?

If it's posible post a sample!

[smartcard]

Originally Posted by Aj_old

Where data should be added? What is the structure of the doc? Name, and so on! Is doc open or excel should open it?

If it's posible post a sample!

Please find enclosed sample doc. I want to keep this DOC as a template and once the button clicked the data will be filled here. I think in that case the DOC should have book marks for fallible data fields?

[Aj_old]

Smartcard the same question again!
Why having this on a separate worksheet in excel isn't good for you!
The doc file will be send to someone or just used fro printing?

[smartcard]

Originally Posted by Aj_old

Smartcard the same question again!
Why having this on a separate worksheet in excel isn't good for you!
The doc file will be send to someone or just used fro printing?

Good idea to keep it on a separate worksheet, but some times Excel is difficult to format to print etc.,