I am writing a macro that copies ranges from Excel into a Powerpoint presentation. Some of the ranges need to be copied as spreadsheet files because the size is not known in advance and they may have to be split over several pages.
I understand how to copy as a picture [Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture] but how do I copy as a spreadsheet? When I use Selection.Copy I get a picture.
I understand how to copy as a picture [Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture] but how do I copy as a spreadsheet? When I use Selection.Copy I get a picture.