word and excel

  1. E

    Copy table from Word to Excel while preserving formatting

    I've been coding VBA for many years but this one is a real head-scratcher. The task is simple - Copy data from a table from Microsoft Word to Microsoft Excel. The challenge: Maintain the formatting of the data from Word, which includes bulleted lists and multiple paragraphs. More...
  2. B

    error message due to cell being blank

    Hi, What do need to add to this piece of coding so that the it doesn't stop if no information is inserted in cell Q5 theString = Range(" Q5").Value 'cast to string theObject.SetText theString theObject.PutInClipboard 'copy from cell B2 to clipboard...
  3. S

    search keyword in multiple word documents

    Hello, I need to search a keyword across multiple word documents saved in a folder. There are hundreds of such documents and its impossible to open each doc and search for the keyword. I am looking for an excel macro which will go into each of the word documents and return the name of the...
  4. B

    Creating a Word Document from an Excel spredsheet - formatting

    Hi, I presently have coding that will create the word document but I was wondering if it is possible to have coding that will help with the formatting of the Word document and the removal of bookmarks that are no used (no information in the corresponding cell in excel) the person fills...
  5. S

    Different Word Template based on cell value

    Good evening, I am needing some VBA to select the correct word merge template based on a cell value. I receive a spreadsheet with all of the data to perform a word merge. Not every row will be the same template. I need the template used to be determined by the value in column "A" For example...
  6. M

    Excel VBA: Inserting "Page X of Y" in a word document at the current cursor position

    Hi MrExcel wizards. :) I have been searching for hours trying to find something to solve this specific problem. I have information in an Excel file, which I want to transfer to a word file. I have everything working perfectly. All i now need is to add "Page X of Y" at a specific location. I...
  7. B

    Emailing a Word Document triggered by a cell selection in Excel

    Hi, I am looking to email a Word Document to an email address from Excel the email address contained in the cell (D24) will change based on the client completing the form - The email is triggered by specific entry in a Cell (C26) there would be a body to the email but also the Word document...

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