word vba

Thanks in advance! I have countless Excel links in a Word document that are used to generate reports. To jump (from Word) to the source of the link (in Excel) I typical right-click on the link, select 'Linked Object' form the Context, then select 'Edit Path' or 'Open Link' I would like to be...

Hi All, I have pieced together a process to save as PDF and to rename the PDF. I am hoping extend the process and to add a cover page (PDF) to the produced PDF. So I am hoping to to have a button to: 1. Create PDF from current word doc 2. Rename the PDF 3. Grab a PDF in a separate file location...

Hi all, I am working on a project that uses a form I have created in Excel to populate Rich Text Formats in a word document in order to streamline report generations. I have almost completed the project but I have ran into a problem I can't seem to figure out. I am fairly new to the VBA...

I've got 2 seperate files. One is a macro-enabled excel(Data) with userforms ad another is a macro-enabled word(Cover Page) with userforms. I want to combine these 2 into a PDF to form a report. Is something like that possible? Could you also please refer to helpful articles on this situation...

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 Team, I have Drop down list content control containing Yes/No in my Word document. I need to autopopulate in the selected cells as Yes as Drop down list content control without pasting as text. Please help with the vba subroutine for word to execute the same task Any help would be highly...

Is there a way to select the second to last row in a table utilizing VBA coding in a Word Document? Thanks in advance for any help.

I am working on 'Word Document' where a text is selected and converted into variable let say CCC. I want to transfer this CCC to 'Excel Workbook' Sheet1 in next empty row. I am trying following code but it seem not doing anything: Set CCC= Selection.Range.PARAGRAPHS(1).Range Set...

Hi I am hoping there is a boffin that can help? I tend to do all my VBA in Excel as an accountant, but I have a scenario where I have to do some VBA in Word and I am struggling with which methods to use. I have a pre-generated word specification document that I need to insert the corporate...

Hi every one, I have fond a code for word doc that copy data form excel sheet to word tables with different criteria. I have 3 criteria to filter excel column"B", if Criteria 1 match with Col B data the copy next col cell data and paste in word doc table 1, and if criteria 2 match then paste...

Hi, I have been Googling for quite a while now, and doing that, I have seen that most macros where written and used by Excel. I want to do a macro in word that will open a specific sheet in the excel workbook and copy its contents to a ready-made word template . Can anyone help me in achieving...

OBJECTIVE: I have a Word file with 275 linked fields to an Excel file. I would like the user to be able to select any range in the Word file and update selected links, and I would like this process to occur without the Excel file opening/closing for each individual link. CURRENT SOLUTION...

Hi, I have been trying to insert four excel tables into a single page in a word document; to be placed at specific locations. The issue I'm facing is that the code until the selection of summaryVal works fine; but nothing after. In spite of setting the right table from excel when I paste it in...

Hi All, I am new to vba. i have found a word vba which is saving individual mail merge to pdf files. But for this i have to pick the folder to store the pdf files. Is it possible to modify the macro to automatically save all files to a particular folder location instead of manually selecting...

Anyone help me with the below show me where im going wrong??? Error listed below -------------------------------- Sub all() Dim wdapp As Object On Error Resume Next Set wdapp = GetObject(, "Word.Application") On Error GoTo 0 If wdapp Is Nothing Then MsgBox "No instances of Word...

Hello, I understand this is for gurus on VBA for excel, however i would really like help on this code ive got. I have a UserForm which finds all bookmarks that i've put in on my document. This is a code i got off of the internet, and there is a Compile Error which i can't solve. here is a...

Hi, I have a Word macro enabled document with ActiveX controls in it. A user can basically select multiple check boxes or select options in combo boxes on the Word Form. There are certain fields that I want to make sure the user fills before closing the word document. Below piece of code...

Hello, I am assigned the task at work to transfer the data from the excel documents into the word document for the final proposals. We have been doing this without a VBA Code, this is quite time consuming process. The clearest way we found to transfer the data from excel is by in the word...

I have below macro for coping all open word docs into a "master" sheet and adding a page break then a blank page after each doc copied. it works fine, however its adding 2 blank pages at the top of the document when it copies, so my first 2 pages on my master are blank. I am not sure how to get...

Hello - I'm trying to pull data from an excel document, but the problem is the excel document automatically loads a userform when it opens. So when I open the excel file using Microsoft Word VBA the code gets stuck on this userform until I manually press the "x" button to close it. It there...