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