Yeah, I tried that trick on a lark after after reading about a similar
situation when copying from Excel to Word. In that case, you needed to
change code from Range.PasteSpecial to Range.Select and
Selection.PasteSpecial.