Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do i export excel data into word using vba?

Status
Not open for further replies.

snowmantle

Programmer
Jun 20, 2005
70
GB
How do i export text from selected cells in an Excel sheet into a newly created word document using a macro or subroutine?

Trying to do the below where 'value' is text in Excel or maybe if poss text in a separate word document that can be copied to the new word doc:

Key: [cell,value]

[A1, "You have selected option one"]
[B1, checkboxOptionOne]

[A2, "You have selected option two"]
[B2, checkboxOptionTwo]

If B1 is checked then the text in A1 is displayed otherwise hidden, the same goes for B2.

So basically have a list of options to tick and then once all options are selected a button to put all the text into a single word document.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top