How to create MS Word document automatically with Dynamic fields
http://www.krishtalk.com/
Excel text manipulation
http://www.krishtalk.com/2018/10/practical-text-manipulation-using-mid.html
Useful Tips on Office Automation
How to create ms word templates
This video shows how to create a template in MS Word using Quick parts, Fields, Bookmarks and VBA macros. Templates are useful for automating word documents. You can store repetitive values somewhere in the bookmark and place them wherever needed.
Download the example here
http://krishtalk.com/2015/05/how-to-create-template-in-ms-word.html
There are 3 steps to create MS word templates.
Step 1
Create a section of bookmarks, which hold the value you enter. These are hidden.
Step 2
Create field code to populate the values. Use ASK filed to get the values from user and store them in the bookmarks created earlier.
Step 3
Create fields where you want to place the values stored in bookmarks. use the FORMULA field to get the value from bookmark and place them wherever you want
code REF Bookmark name
Finally you can create a macro to update all the values. For this you can create a button and assign the code to it.
code
Private Sub Update_Click()
Fields.Update
End Sub
Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: http://krishtalk.com/
Google Plus: https://plus.google.com/+KrishSanj/
Twitter @iTwittt
https://twitter.com/iTwittt
Видео How to create MS Word document automatically with Dynamic fields канала Krishna S
Excel text manipulation
http://www.krishtalk.com/2018/10/practical-text-manipulation-using-mid.html
Useful Tips on Office Automation
How to create ms word templates
This video shows how to create a template in MS Word using Quick parts, Fields, Bookmarks and VBA macros. Templates are useful for automating word documents. You can store repetitive values somewhere in the bookmark and place them wherever needed.
Download the example here
http://krishtalk.com/2015/05/how-to-create-template-in-ms-word.html
There are 3 steps to create MS word templates.
Step 1
Create a section of bookmarks, which hold the value you enter. These are hidden.
Step 2
Create field code to populate the values. Use ASK filed to get the values from user and store them in the bookmarks created earlier.
Step 3
Create fields where you want to place the values stored in bookmarks. use the FORMULA field to get the value from bookmark and place them wherever you want
code REF Bookmark name
Finally you can create a macro to update all the values. For this you can create a button and assign the code to it.
code
Private Sub Update_Click()
Fields.Update
End Sub
Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: http://krishtalk.com/
Google Plus: https://plus.google.com/+KrishSanj/
Twitter @iTwittt
https://twitter.com/iTwittt
Видео How to create MS Word document automatically with Dynamic fields канала Krishna S
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to navigate from Finder to terminal and terminal to Finder in MacPower Point Custom shape with images | create a product catalogue[SOLVED] Face ID and passcode is not visible iPhone. Here is the quick fix.#shortvideo #shorts #shortsfeed #viral #viralvideo | How to delete horizontal line in MS wordHow to Create MS word automatically with Excel in Apple MacBook#shortvideo #shorts #short Select only the numbers in the MS Excel[QUICK FIX] How to enable Auto Save in VS Code#shorts #short #shortvideo Search bookmarks in ChromeEasy and Quick | How to convert a Number Into Text in MS Word without any VBS code.#shorts How to copy and paste phone numbers into iPhone dialer | iPhone Phone AppJio True 5G Unlimited 5G data | Jio 5G Welcome Offer at no extra costHow to enable 5G on iPhone 14 with Airtel and Jio True 5G | BangaloreHow to Close an Application window on Mac OS[ ENABLE ]Mac OS Battery Percentage Indicator | How to control the Keyboard backlight Non-touch BarExcel in Mac | How to record and edit Excel macros in Apple Mac Pro, MacMS Excel Quick Analysis tool on Data formatting and AnalysisMS Excel How to get live details of each country in the worldMS EXCEL How to align text across multiple cells without merging[SOLVED] Where is strikethrough Option in Mac Notes | How to add a shortcutHow to Create and Install SSL self signed certificates | SSL with WebsiteNew MS word features in OFFICE 365