klionlarge.blogg.se

#WORD MACRO TO ADDPDF TO WORD HOW TO#
#WORD MACRO TO ADDPDF TO WORD UPDATE#

Set iApp = CreateObject("Word.Application") Then, declare the necessary variables for the macro. VBA Code Explanation Sub OpenWordAndSaveAs()įirst, provide a name for the sub-procedure of the macro. You can change the new file path from the opened word file too if you want to.Īnd as you can see from the above image, the old student information is now updated “ Dean Ambrose” becomes “ Jon Moxley” and “ Danial Bryan” becomes “ Bryan Danielson” and saved as the new “ Student Information File” Word file. After the successful code execution, there will be a new word file named “ Student Information File” opened up automatically at the location provided in the code (in our case, we saved the file at “ C:\ExcelDemy\” location).You can also just click on the small Run icon in the sub-menu bar to run the macro. Press F5 on your keyboard or from the menu bar select Run -> Run Sub/UserForm.SaveAs2 Filename:=("C:\ExcelDemy\Student Information File"), FileFormat:=wdFormatXMLDocument, AddtoRecentFiles:=False Set iDoc = (Template:="C:\ExcelDemy\Student Information.docx", NewTemplate:=False, DocumentType:=0)

Then, copy the following code and paste it into the code window.

Next, in the pop-up code window, from the menu bar, click Insert -> Module.

In the beginning, press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to open Visual Basic Editor.

The steps to open the “ Student Information” word document, modify the information and save it as a new word file named “ Student Information File” with VBA in Excel are given below. Embed VBA to Open the Word Document and Save As a New Updated Word File

#WORD MACRO TO ADDPDF TO WORD HOW TO#

Now we will learn how to replace the old student information – “ Dean Ambrose” and “ Danial Bryan” – with the new ones – “ Jon Moxley” and “ Bryan Danielson” – and save the modified file as a new Word file or PDF file with the VBA code in Excel.ġ. So, let’s store those two updated names in our Excel worksheet.Īs you can see from the image above, we stored “ Jon Moxley” in Cell C6 and “B ryan Danielson” in Cell C7.

#WORD MACRO TO ADDPDF TO WORD UPDATE#

Suppose we want to update the student’s name “ Dean Ambrose” to “ Jon Moxley” and “ Danial Bryan” to “ Bryan Danielson”. We will update the two names indicated in the above picture as an example for the sake of this article. What we are going to do with VBA code is, we will open this word file, modify the data if we have to and then save it as a new Word file or PDF file in our computer system.

This is a word file named “ Student Information” stored in our computer system at C:\ExcelDemy\ location. Implementations of Excel VBA to Open Word Document and Save As PDF or DocxĬonsider the following image of a word file.