Advertisements I’d like a VBA macro in word to find all instances of a user-selected string in a document (e.g., "a dog") and insert a corresponding user-selected reference numeral in parentheses (e.g., "(102)") immediately following each string. I have made a find-and-replace style macro but, in tracked changes, it shows as artificial revisions the deletion… Read More VBA macro to find all instances in a doc of a string, e.g., "a dog", and insert in tracked a reference numeral, e.g., "(102)", immediately afterwards

Advertisements I have code that creates fields on a word document based on selection, but when it is done it has the field selected. I want to select the position right after the field. So if there is a FIELD_ with _ being the position right after the field, it is what I want to… Read More Set Cursor position to right after selection in word VBA

Advertisements new VBA user here. I have an MS Word document with 30 tables that I created outside of Office. I would like to insert a page break after every table in the document. I tried this VBA macro to insert the break at every paragraph as a placeholder for the table: Sub InsertBreak() Set… Read More How do I insert a page break after every table in a document?

Advertisements I tried to export a word document from an excel macro as PDF, but when I try to run the macro the error "Named argument not found" pops up and highlights "Type:=", I don’t know if I need to add a reference or something, What am I missing? Dim wdApp As Word.Application Dim wdDoc… Read More Tried to export file as PDF but had error Named argument not found excel VBA

Advertisements I have a Microsoft Word file, Tst.doc that contains the following sentences: Sofa 1. Sofa 2. Chair 1. Chair 2. Seat 1. Seat 2. I need to extract all the sentences containing any of the words (sofa,chair,seat) to a second file named OutputBin.doc that is stored in a fixed location. I wrote the following… Read More How to extract sentences containing any of several words using Word VBA

Advertisements I am working on a script which saves images to word file. I have been able to create a function to export images. def exp_images(): #export images to word file document = Document() paragraph = document.add_paragraph() script = paragraph.add_run() script.add_text(‘This is a test sentence’) script.add_picture(‘image1.png’, width=Inches(6.5)) document.save(‘demo.docx’) if __name__ == "__main__": exp_images() The only… Read More how to export images to word file?

Advertisements I am beginner at coding with VBA. So, although the following code works very well, I am looking for a way to optimize and reduce it. Its objective is to: 1- paste a table from Excel into Word without losing Excel format 2- process the pasted table 3- move out of the table, then… Read More Paste a table from Excel into Word then transform it

Advertisements I have a project at my school and I need to calculate the average of all the grades, we’re using ms word vba. I know the code is soo dumb but im new and young. >Solution : Add the line Dim average as Double near the top, and change the assignment lines to use… Read More What is the format of coding the average in ms word vba? I'm new sorry Please be nice

Advertisements I recently asked a question about how to go about producing a dynamic toolbar in MS Word which I finally have working. However I have a set of variables which are produced in a userform, from which I want to call a function in the parent module to invalidate the UI in order to… Read More Calling a RibbonControl function from a userform

Advertisements In analogy to this question, I would like to script a VBA script that counts words formatted with a certain document style, more precisely: a certain paragraph style. Sub CountTypeface() Dim lngWord As Long Dim lngCountIt As Long Const Typeface As String = "Calibri" Const MyFormat As String = "My Paragraph Style" ‘Ignore any… Read More Count words in a Microsoft Word document by document style?