vba & excel to word

  1. J

    Replacing Merge Field in Word Removes Spaces

    My Excel macro opens a Word template and replaces a specified merge field with the text from an identified cell. This all works great except that when the merge field is replaced, either the preceding or following space is being removed too. For instance... Dim wrdApp As Word.Application...
  2. M

    Word Function returning Run Time Error '438 when called in Excel

    Hi Everyone I have been creating a macro in excel that will pull information from an excel sheet and insert into a word document. After much trial and error I have managed to get it to insert all the information I want but I am now stuck on changing the formatting of what is inserted. After...
  3. C

    Help! Exporting Excel data to Word

    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...
  4. P

    Excel Mail Merge Macro: Write to Word Document loop issue

    I have data set that contains ID numbers on Column A that repeat multiple times and vary from ID # to ID #. For example ID # 123 may take up 17 rows, while ID # 456 may take up 5 rows. To add complexity, within each ID #'s rows, there are two types of data they can fall under (i.e. ID # 123...

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