excel to word

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166
hi, i have a set of data in excel. i want that all the data in excel active worksheet shall be automatically transferred to ms word when i click a command button... anyone can figure it out? tnx..
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

sanrv1f

MrExcel MVP
Joined
Jan 1, 2009
Messages
3,474
Office Version
  1. 2016
Platform
  1. Windows
did you try mail merge?
 

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166
hi, nope, i didn't try it. coz i want only a command button will do the export for me from word to excel... is it possible?
 

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166
hi, can anyone figure this out? im just new to vba programming.. tnx...
 

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166

ADVERTISEMENT

hi everyone... is it possible?
 

miyat

Board Regular
Joined
Nov 27, 2009
Messages
166
please help me... does anyone can able to create a code for this? im just a novice.... im sorry for double posting...
 

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
Did you have a look at the link I posted?

I do think you might be trying to bite off a bit more than you can chew if you have no VBA experience. Maybe learn to walk with it before you try to run.

Dom
 

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top