Excel macro

Desktop Apps, Web Programming — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original Hi, Mac has Excel, I need that all lines from the A column be moved to Word each line to a new page in Word in the same document so that I can transfer them to print one time to different sheets.I got this macro. But when running sometimes Runtime 5 flies, or it starts word creates a document but +- with 30 lines starts by two lines on a sheet to add for an unforgettable reason. Sub CopyColumnToWord() WordApp as Object WordDoc as Object Dim LastRow As Long Dim ws as worksheet Dim Cell as Range Create a new copy of Word Set WordApp = CreateObject (“Word.Application”) Create a new document in Word Set WordDoc = WordApp.Documents.Add WordApp.Visible = True ' We show the Excel sheet from which we will copy the data Set ws = ThisWorkbook.Sheets("List1") ' Change the name of your list if necessary ' Determine the last line in column A LastRow = ws.Cells(ws.Rows.Count, “A”).End(xlUp).Row Copy data from column A to Word For Each Cell In ws.Range("A1:A" and LastRow) WordDoc.Content.InsertAfter Cell.Value & vbCrLf The next cell Cleaning the variable Set WordDoc = Nothing Set WordApp = Nothing Set Cell = Nothing The End Sub Maybe it's a matter of some settings, I need to solve this task.You can use this macro you can other without the difference would only work.

Proposals 5 Discussions 2

Polina M.

18 2

Projects 18
Rating -
Rating 888

Budget: 500 UAH Deadline: 2 days

Hello to you!
Interested in your project. Please contact me to discuss the details and deadlines of the project.

There is such a macro that fully corresponds to TZ.

Anton T.

345 0

Budget: 567 UAH Deadline: 1 day

I will review the issue of transferring data from Excel to Word to Mac.
First, specify which Excel and Word are used.

Igor Lyalchenko

6 1

Projects 6
Rating -
Rating 221

Budget: 500 UAH Deadline: 1 day

The deadline is not specified from the moment of acceptance of the conditions, but from the moment of the appearance of electricity I have as an executor (a programmist without electricity can only shrink, so the text is below)

The error is associated with the incorrect call of the function (from the announcement of the transferred parameters or the error of opening/creating the document but then the call of the function without verifying the success). Well, this is a guarantee question for a couple of hours to the person who wrote the code with a description of when exactly (with what actions or in what situation) this error occurs.