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!
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.