word 2016

Hi Team, I need a vba code which can jump to the same location in the next column same row in the same position in Word table as attached in the image. On pressing Alt+Right or Tab the cursor moves to the starting position of the cell. I would like to jump the cursor directly to the same...

Hi, I have a spreadsheet that is populated with data. Each column has a header and there can be many rows. I want to copy/export a selected row of data to a Word Template, Save the Word file as Filename.Doc Close trhe Word Application and then return to Excel (Command Button that calls...

Hello, Could you please point to why my MS Word 2016 cannot view (and save) bar codes. Upon opening (or saving) a document that already has a bar code my MS Word converts the bar codes to text. Do you know how to fix this behavior? Regards, Rajesh

Greetings my fellow Excel enthusiasts, I am hoping someone here can help me develop a code that will export data from excel to a word template, generate a report/proposal and attach it to an email in a pdf format. I already have the code to generate the proposal but can't seem to figure out the...

I have the following code but can't figure out why when I export the information to word and generate a "proposal" it opens the actual template. When the user saves the report it's saving it over the original document. Is there any way we can fix it so that word uses the template to generate a...

I created a spreadsheet that pulls data from various tabs and summarizes it on the main page. Excel then exports the data to a word template. What I would like to do is have the data converted to PDF and attached to an email. Can anyone help me tweak the VBA code I currently have to accomplish...

Hello everyone, my boss has me working on a spreadsheet that pulls information from various tabs into 1 "Summary" tab. We then VBA code to put the information into a table (removing any blank rows in the process) and transfer to a word template called "Proposal" located in the same folder as the...

Hi, I have a spreadsheet I am preparing for my boss that requires me to review column B (B28:B47) on the "Summary" sheet, determine which rows have data and transfer a portion of the rows (columns B, C, D, E & F) to a word template called "Proposal". I have limited experience with VBA but I...

First time learning VBA. I want to write a VBA script to add a hyperlink to each line of a range of selected paragraphs in word 2016. The hyperlink would open a document with the filename matching the line of text selected and are stored in the same folder. Here what I found and put together...

Hi all, have searched a lot to find a solution, hope some can verify what my problem is and how to solve it. I want to search/replace text in a Word doc from Excel. This should be plain sailing, multiple solutions exist online. However, I can only find the text, and fill the replace dialogue...

Hey all. I'm using Office 2016. I'd like to make a macro that loops through each heading in a document, and then creates a bookmark at the heading's location using the heading text (modified as necessary) as the bookmark name. Most of the headings are in X.X.X.X format, such as "3.3.4.1...

Hi all, I've hit a brick wall, having Frankensteined bits of code. I am not a coder, so I apologise if this is a mess. Basically, the code I currently have will combine the revisions and comments from multiple Word documents in a specified folder into a single document. This is useful if a...

I have a Word document with multiple tables. In each of those tables, I have multiple labels. Then, I have a macro, that loops through all the labels and I would like to it look at the name of the label and name of the table. From this information, it will look into excel file and locates the...

I'm trying to make a letter from data from access. I have about 40 or so records to print out on a work document. I've set up the document with bookmarks. I'm getting the data from a query. So far this sorta runs.... I click the cmd button.... nothing happens. When I click on the actual file...

hi all, i'm trying to create a command button in word and attach a macro that automatically saves the doc as a pdf to a specified folder with file with the name coming from 2 bookmark references with a space and dash in between name. here is what i have so far: Private Sub...

It it possible to execute (run) this part of my macro in the background, so the Outlook Appointment window doesn't show? When I delete the " olAppt.Display ", it doesnt add the Selection to the body of the appointment anymore. Set olAppt = Outlook.Application.CreateItem(olAppointmentItem)...

Hello guys, Please someone help me. I need to extract +- 300 comments from Word and put them in an excel file. I've found this code in a previous post: Public Sub FindWordComments() 'Requires reference to Microsoft Word v14.0 Object Library Dim myWord As Word.Application...

Hey, I am currently in the process of automating audits at work. Currently we are working off an interface in excel and writing the reports out manually in excel. What I am after doing is installing a button that can merge certain cells in to marked places in a word template. For example...

Hi everyone, I'm an aspiring author, and want to keep track of the word counts in my chapters. At the moment each chapter is a different file. I would like a macro to go into each file, and tell me the word count in an excel table, for each chapter. I'm usually pretty good at figuring macros...