PDA

View Full Version : Excel Userform that is published in Word



bi2L'sy
06-09-2011, 01:01 PM
Hello,

Any ideas on sending data from a Userform and publishing it in MS Word.

Thanks for doing what you do!

GTO
06-09-2011, 05:47 PM
Greetings bi2L'sy,

Welcome to vbaexpress :-) I'm sure that you will be very glad that you joined, as there are terrific folks here.

Reference your issue, I would suggest zipping a small example wb and the destination Word document, so we can see what you are trying to do.

Mark

bi2L'sy
06-10-2011, 07:55 AM
Thanks for the warm welcome. I attached an example WB (training for making forms) that the form when filled out will fill in the cells on sheet1. I would like to put another command button on the sheet to then take that info and put it into word. I did not attach a word doc because I am not too sure what the next step is. any direction would be greatly appreciated.

Thanks again.

Kenneth Hobs
06-10-2011, 08:31 AM
There are lots of ways to do it. Here are a few for youy light reading pleasure.

TypeText Method
http://www.excelforum.com/excel-programming/650672-populate-word-document-from-excel.html#post1946784
http://www.excelforum.com/showthread.php?p=1946784
http://vbaexpress.com/forum/showthread.php?p=169877
http://vbaexpress.com/forum/showthread.php?t=24693

Copy from Excel, paste to Word
Lucas, http://vbaexpress.com/forum/showthread.php?p=178364

FormFields
http://www.mrexcel.com/forum/showthread.php?p=1639696
http://www.mrexcel.com/forum/showthread.php?t=333200

Add Hyperlink to Bookmark
http://www.excelforum.com/excel-programming/664078-use-excel-vba-to-add-a-hyperlink-to-a-word-document.html#post2006430
Steiner, http://www.vbaexpress.com/kb/getarticle.php?kb_id=126
Colin_L, http://www.mrexcel.com/forum/showthread.php?t=358054

Save OLEObject as MSWord Document
http://vbaexpress.com/forum/showthread.php?t=21619

Add Table to MSWord
http://vbaexpress.com/forum/showthread.php?t=23975
http://vbaexpress.com/forum/showthread.php?p=168731

Import Word Tables
vog, http://www.mrexcel.com/forum/showthread.php?t=382541

Save OLEObject as MSWord DOC
http://vbaexpress.com/forum/showthread.php?t=21619

Get Optionbutton info from MSWord DOC
http://vbaexpress.com/forum/showthread.php?t=22454

FindReplace Text
http://www.excelforum.com/excel-programming/682014-replace-word-in-ms-word-with-varable-from-ms-excel.html

Bookmarks
http://vbaexpress.com/forum/showthread.php?p=185718

bi2L'sy
06-10-2011, 01:13 PM
I really appreciate the info, and thanks so much for the help. This should get it.

Aussiebear
06-12-2011, 01:52 AM
Kenneth, how did you remember the links?

Kenneth Hobs
06-12-2011, 06:50 AM
I started saving the links like that in a Module in an Excel file with the code to remind myself and to help others like this. If I don't participate in those, I save the link if it illustrates a concept that I want to explore later.

I should save links of interest to me in a database or even Excel but I usually just make a folder and save the file or make a file with the code. I most always save the link as a comment in the vba code. I save snippets of code that are handy in a Module in my personal workbook.

Aussiebear
06-14-2011, 12:32 AM
That's not a bad idea