wdapp

  1. Q

    PDF Created from VBA Button won't open

    I've got this code below which creates a PDF document. The error message appears saying I'm unable to open the document because: it is either not a supported file type or because the file has been damaged VBA Code: Private Sub Command273_Click() Dim wdApp As Word.Application, wdDoc As...
  2. M

    Setting a style to a word document created from Excel VBA

    I have some code I've used in a few projects that creates a new word document (from excel vba) and pastes in a string. I remove the last character (a ") and set the font and font size. What new in this part of the code is I want to set the style to No Space. I recorded the vba from word and...
  3. G

    Run time Error '462' The remote server machine does not exist or is unavailable

    Hello, I have created some code to open a word template from Excel and then fill in some details via the Bookmarks, however every other time I run it, I get the following error "Run time Error '462' The remote server machine does not exist or is unavailable". I have tried to understand what...
  4. J

    Adding Autofit to window with my copy&paste Excel range to Word macro

    This macro copies a range in excel and pastes to word, while Word opens up in landscape. I would also like it to autofit after pasting in Word. Any help would be appreciated. <code>Sub PasteToWord() Dim wdApp As New Word.Application, wdDoc As Word.Document With wdApp...
  5. B

    VBA: change orientation to Landscape for word document converted from excel

    Dear all, I have an excel file which I want to convert to word. As the column number is big, the word document doesn't show all information, some of columns are not visible. I changed manually the orientation to Landscape and I was able to see all data. Issue VBA the change orientation to...
  6. J

    Passing Excel Userform String to a Word Form Template to print out

    I really need help with this one, I have run into the 255 char limit of passing a string from excel to word. The following is what I have attached to the print command: Private Sub cmdPrint_Click() Dim wdApp As Object, wd As Object, ac As Range On Error Resume Next Set wdApp =...
  7. D

    Copy from Excel, Paste into Word Error

    Morning All, I have an issue with he code below; The code selects objects from my excel workbook and pastes it into a new word document fine, however I get an error when adjusting the margins. The error I get is a Run-time error '462': - The remote server machine does not exist or is...

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