word

  1. M

    Find Function VBA Named Argument Not Found-Runtime error 448

    I am writing a macro( late binding) that runs through a word document and highlight all the values that is contained in my cell range in Excel. I have used the find function which works fine until I add the argument IgnoreSpace:= True, which I don't understand why it's resulting in error...
  2. P

    Word create or open with VBA functionality?

    If I am thinking about this in the wrong way do not hesitate to say. I am new to VBA but I am not new to programming. I want to be able to automate the creation of Word documents. That is when the document does not exist already. If the document exists, I would like just to open it. Where I am...
  3. T

    How to change or replace multiple cell name in Microsoft Excel chronologically?

    I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2"...
  4. S

    Excel Customer List to Word Offer and Invoice template, with unique invoice number list and buttons to create

    Hi Excel Experts, I'm coming to you with a question, I'm helping out my friend with digitalizing their tools for their business, starting with a customer list, so they can use the details later for mailings, (now everything is on paper and in the word templates, so they don't have a nice...
  5. nburaq

    Find a word combination of letters and numbers

    Hi, I have a data set of descriptions and I need to find words in descriptions combined with numbers and letters. As an example cell A2 includes a sentence "Repair A4040D" so cell B2 should include information "A4040D". The equipment number is combination of letters and numbers max of 6...
  6. D

    VBA - email an X% zoom screenshot of an open Word document, with file also attached

    Followed below instructions for the below code, only for step 7 there were no "Microsoft Outlook Object Library", so used "Microsoft Outlook 16.0 Object Library " But nothing happens when code runs, at all, not even an error. Using below code as a next best thing to figuring out how to...
  7. T

    How copy a Word table into Excel and not lose the formatting ?

    Hi guys, how are you? I need your help because I want ran from boring and hard job to work with PDF and I want to convert the table from PDF to Excel. I read different forums and watch different videos on youtube but cant find the solution. I found only good advice to convert PDF to Word...
  8. T

    Help please! Can't figure out how to automatically generate reports and include task description in the generated Excel word doc

    Hi all - I am very new to using Macros with Excel and I am looking for help. I am using code to attempt to automatically generate a word doc with upcoming deadlines/due dates in my Excel sheet. Currently, it will only generate a word doc if I manually run the code. Also, I am having trouble...
  9. M

    VBA - paste picture into word from path

    Hello All :) Currently I have vba code: 'Some code above If OfertomatMain.cmbUnderwriter1.Value <> "" Then For b = 2 To 20 Step 1 If OfertomatMain.cmbUnderwriter1.Value = wudoc.Cells(b, 1).Value Then Let underwriterstanowisko1 = wudoc.Cells(b, 2).Text Let...
  10. D

    Copying data from Excel sheet into Word

    Hello, When I copy from a Excel sheet data into Word it rounds the numbers behind the . I think all this is because of all the different cell formats all the columns have. Is there a way to copy and paste the data with all the numbers behind the . like 12.03767 ? After copying in Word this is...
  11. I

    VBA Code to Open Word Template and create new document per list of names

    Hello, I have somewhat of an advanced question... I have a long list of names in a column in excel (range name, "Names"), what I want to do is create a code that I can run that will open a template (named "CART") and based on the list of names the code would open a copy of the template and...
  12. R

    MS Word - Bookmarks in Headers not updating correctly

    Hi all, I've got a document I'm using as a template with several sections. Page 1 is a title page with the: Document Title Published Date Updated Date Those three items are all bookmarks. Those three items are also included in the header of each page. When I'm ready to finalise the file...
  13. Chris_010101

    Force Save as PDF

    Hi All, I know this is not necessarily Excel-related, however, it is going to be VBA related. I have created a return-to-work form in word, which is sent to managers to complete return-to-work interviews for sick employees. The document is restricted and only form fields can be completed...
  14. gravanoc

    Accessing an open Word doc from Excel causes "Locked for Editing" dialog to appear

    I'm experiencing an issue with exporting the contents of a Word document to PDF. After pasting a table from Outlook into Excel, certain parts of the table are retained, then the new table is pasted into Word. The Word document is saved using a specific filename, the date, and a number to...
  15. J

    WORD: Macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black

    Hi, Can anyone help with a macro to Cycle Through Headers & Remove Merge Fields / Change Formatting to Black? Thanks.
  16. A

    Macro that creates a word document (and then a PDF) very slow

    Hello MrExcel, I have a macro that essentially exports text in 3 columns into a word document before converting to a PDF. I have had to do this as the text in 1 of the columns is well over 300 characters and can't be done in excel. Unfortunately when i run the macro it takes about 13 minutes...
  17. S

    Excel to Word

    I have a pre-built Word form document that I use that has multiple fields that I fill out (customer name, dates, etc.). I usually copy/paste information to this document from other sources (Excel, Word docs, etc.). QUESTION: I need to create a way to automate moving the required data from...
  18. V

    Reading properties of a Word document

    Hi, I have a file that contains two columns: A - file path and B - Title. To select a file, I double click in column A (let's say, A14), which opens an Explorer window. I make my selection and the path of the selected file is inserted in the double clicked cell. Now, to get the title of said...
  19. D

    Adding images in table with formatting into Outlook using a file picker

    I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...
  20. Akuini

    VBA Macro to create Word & Phrase Frequency

    This macro generates word & phrase frequency. You can set the number of words contained in a phrase as needed, in this part: Const sNumber As String = "1,2,3" You can also set what characters should be considered as word characters, in this part: Const xPattern As String = "A-Z0-9_'" but...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top