How to create and use a Word macro to insert any information with one click. Fast and efficient.
ฝัง
- เผยแพร่เมื่อ 13 ก.ย. 2024
- Increase the efficiency of your Word work with these easily learned procedures.
An explanation and demonstration on how to create a Word macro to insert data with one click from a macro button in the Quick Access toolbar.
Also shows how to insert data into the Quick Parts Gallery and use a macro to place the data in the document
Web: unitedcomputerc...
Facebook: / unitedcomputerconsultants
Twitter: / geoffhudson7
Thank you so much! You saved me so much time with this tutorial!
Glad it helped!
Thank you so much for your tutorials!! I've learn't so much and I hope it will help with my job assessment today. You are clear, easy to understand and it's great to have the document to follow along.
Many thanks Wendy. I am happy to help.
Hi again - just thought I would let you know I ACED the assessment today!! 29 out of 30 for Word and 100% for Excel... amazing considering there were at least 10 things in each I didn't know prior to watching your tutorials! Fingers crossed I get this job. Thanks again :)
Good on you Wendy ! I am proud of you. Well done !
Yes, thank you so much for this video. Ive been watching some other useful videos on macros, and this was a slightly different way. Looking forward to trying this out. At least 60% of my job jas a repetitive element to it. Cant believe Ive used developer template for so long without employing macros. Anyone using drop down fields that have a lot of content should be using this. By the way do you know if a macro, can unlock a Developer form which is already using drop down fields and then insert another field either drop down or type in the box, then lock form again? If 90% of clients etc dont require certain questions because they are NA, it would be an easy way to keep the document as short as possible without having to enter “Not applicable” if they arent there in the first place? Hope this question makes sense
Thank you! This worked very well and was easy to follow.
Thank you Rosanne !!
This was very helpful! Thank you for posting.
My pleasure absolutely...and what a lovely first name !
Thank you for this video, I have been researching for ages on how to assign a macro to a button/icon without having to use vb code and this has partly answered my question. My understanding is that quick parts are applicable to the application, how do I assign this to travel with a document? For example a form or template that is residing on another computer without having to create it on the remote computer.
You need to save the document containing the quick part as a .docm type of file.
You are my hero thanks!
My pleasure !
Thank you so much for posting. This was really helpful for my assignment. 🙏🏾🙏🏾
Glad it was helpful!
Thank you!
You're welcome!
very useful video. Thanks alot united computers.
Glad it helped
very informative video. Thanks for such wonderful information
So nice of you
Hi, thank for posting this video. Is there a way to populate four other data fields driven from one master field? all with different data
Not that I know of
Thank you, It really helped me with my assignment.
You're very welcome!...and you have a nice channel. Greetings from Oz
Very helpful. Thank you 👍😎🇦🇺
You are very welcome John
BRILLIANT of course!!!
Thanks Gill !!
Thank you
You're welcome
Another excellent video!
Thank you "D"
Excellent this work, congratulation!
Thank you. I appreciate the kind comment.
Is there a way to insert and format text based on its location within the document? For example, next to xxxx
Thank you for your comment Josh. I would be inclined to use the Edit>Find command to go to the data you want to insert next to.
Sir as per your micro tutorial. Can I create the same button in the word
document
Yes
Wow, this is amazing. I was looking for that for a while. Thank you very much ^^
Id like to ask if is possible to create a button, just like this, but instead of the Acess bar, the button would be inside the document. So I can click on it ,then it will copy the text, then I can paste anywhere I want
Create a button in a document, right click on it, and "assign macro". You will of course need to create the macro first as per the video
Not sure if Macro is what I'm looking for. I created a fillable form on MS Word 2013 and would like to add a button to clear all fields not just the radio buttons. I also need a print option button. Right now all I have is a Submit button that will send it as an email as that's the only thing I could find online that gave me the codes. Can you please help? Also, I saved it as Macro Enabled Template but did not restrict editing would that still work? This form will be used by Managers and sent out to other people as well to fill out. First time ever to make a fillable form so a beginner here. Thanks in advance!
You can easily create a macro to issue a print command. Can I assume you know how to write simple macros ? The restriction issue should be OK.
I think i know what you are asking, If you want a blank form, with just the questions and fields which I always try to keep one as the master, that I dont even touch ( It sucks when you accidentally start typing on the master , so I try to tuck it away under a name I wont select.). Cannot even begin to tell you how many times Ive accidentally used wrong master template inputting data . For me its best unless I am making a UNIVERSAL CHANGE TO TEMPLATE FOR ALL FUTURE USE- / update, You / I can just use the save as button and give it a new name , like “Xyz template to share with manager”. That way no client or other info has been inserted into document by accident
sorry for the delay as it looks like you asked this a few yrs ago😮
I have a very long text document in which the person's name is repeated several times. This txt document has to been done for several different persons. I want to use a macro button in the field name so that I have to click the macro button just once to fill all the field's name in the template document. Would you please make a video to show me how? Thank you.
Please refer to the following link to see the procedure gregmaxey.com/word_tip_pages/repeating_data.html
Hi Geoff, It works well but when I close word down and open it up again and try and click the button to insert my picture, it gives me a Microsoft Visual Basic error of: Run Time error 5941. The requested member of the collection does not exist ???
All I want to do is have the feature to insert my company logo into word when I click the button.. Can you help??
Make sure you save the file as a ".docm" type.
@@unitedcomputers Still problem continues. Saved it as .docm .dotx etc
thanks for nice explanation. i have a question pleas .: if i need to add a command botton inside the word FORM or templat, THIS TEMPLATE HASE SOME FIELDS TO FILL IN the fields are all in type plain text content conrols. i want to write a code for the command botton that save the document as the content of studentNAME field (plain text content control), and to save it into a specific bath directory, how can i write the code pleas ? can you drope the line code that do this when i click in this command botton.? pleas your answe and thank you in advance. (ps i dont want to print the command botton in paper when i print out the document . can i make the command botton unprinted?)
Thank you for your message. The procedures you require need to be written in special macro code, which unfortunately I am not able to do.
@@unitedcomputers thank you any way .
@@unitedcomputers شكرا جزيلا
The title of this video can be very misleading . It is the second video shown when someone searches how to create input boxes in word macros.
I'm looking for a pre written macro to use in VB in Word to save as PDF to desktop with Title as file name. So one click. Can anyone help?
Sub Macro1()
'
' Macro1 Macro
' Save file to desktop as PDF named "File"
'
ActiveDocument.ExportAsFixedFormat OutputFileName:= _
"C:\Users\DELL\Desktop\File.pdf", ExportFormat:=wdExportFormatPDF, _
OpenAfterExport:=True, OptimizeFor:=wdExportOptimizeForPrint, Range:= _
wdExportAllDocument, From:=1, To:=1, Item:=wdExportDocumentContent, _
IncludeDocProps:=True, KeepIRM:=True, CreateBookmarks:= _
wdExportCreateNoBookmarks, DocStructureTags:=True, BitmapMissingFonts:= _
True, UseISO19005_1:=False
ChangeFileOpenDirectory "C:\Users\DELL\Desktop\"
End Sub
Please publish Macros in Excel
Gopala Krishna I am working on an upload, but need to make it as understandable as possible. It will take some time.
HELP! I am getting runtime error 5941. What have I done wrong?
Make sure you have a document open. Otherwise open another document and try again. You might like to Google "runtime error 5941" for more information.
..and save as ".....docxm"
I am so sorry I do not have a solution for you, my friend. I dont think you have done anything wrong, but the Google search I suggested shows you are not alone on this one. :-(
@@unitedcomputers Its Ok. I figured it out. Under Modify Building Blocks, Save in - Normal.dotm. Right click the object in Quick parts and Edit Properties to get to Modify Building Blocks. Cheers & thank you. Please keep up the good work.
Great stuff !! Nice to know I am corresponding with a genius ! :-)
Do you live in a farm ?
Yes...but the rooster had a very short life, my friend. The shotgun blast did not record !!! :-)
@@unitedcomputers LOL, after the shotgun blast there was no meat left for soup 😁
LOLOLOLOLOLOL...yes I wondered where he went !