I have some vba code which creates a new Word document, then pastes some content from Excel in. This appears to work fine on Windows PCs but reportedly won't work on a Mac. I don't have access to one to investigate the error further so wondered if anyone knew what my issue may be and if I can adapt my code to resolve this problem?
VBA Code:
Sub Excel_to_Word()
Dim wdApp As New Word.Application, wdDoc As Word.Document
With wdApp
.Visible = True
Set wdDoc = .Documents.Add
With wdDoc
Range("C11:F22").CopyPicture Appearance:=xlScreen, Format:=xlPicture
.Range.Characters.Last.Paste
Application.CutCopyMode = False
Range("C27:E41").CopyPicture Appearance:=xlScreen, Format:=xlPicture
.Range.Characters.Last.Paste
Application.CutCopyMode = False
wdApp.Activate
MsgBox "Your tables have successfully been exported to a new Word document."
End With
End With
End Sub