wdapp

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

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

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

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

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

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 =...

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