exporting spreadsheet data to ms word!

**miyat** · 12-10-2009, 04:00 AM

hi everyone, i have a data in excel workbook sheet2... i want to find a code that, when i click a command button in sheet1, all the data in sheet2 will be exported to ms word... with the same format, or the same page set-up in the excel to word document...

**teylyn** · 12-10-2009, 04:13 AM

exported to ms word.

.... as an Excel object, embedded or linked ...?
.... as a table in Word ....?
.... simple copy and paste ...?
.... paste special options ...?

with the same format, or the same page set-up

Some more detail might be helpful. Attach a sample Excel file and a sample Word file with the desired result.

**miyat** · 12-10-2009, 04:21 AM

hi teylyn... tnx for the response... i have attached here the sample file... i want all the data to be exported in the word.. is it possible? tnx...

**teylyn** · 12-10-2009, 04:56 AM

Attach a sample Excel file and a sample Word file with the desired result.

..............

**miyat** · 12-10-2009, 05:13 AM

hi, i have attached the excel file and the word file... the word file have an example of the first part of the excel to be exported... i want the whole data in the excel will be exported to word... with a command button that have vba.. is it possible snowblizz? tnx..