Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to do a macro to copy paste sheets into PPT and I'm finding an issue on this.
I've noticed that depending on the resolution of the screen the image that is pasted in PPT is changing. For exmple if the resolution is lower the image is croped.
I did the same manually (without macro) right clicking the sheet I want to copy and pasting it to PPT and nothing changes.
Did someone have this issue already?
Thanks
Hi,
may be you haven't set the parameters like
with PPSlide.Shapes.Paste
.Left = 40
.Top = 130
.Width = 100
.Height = 275
end with
The problem is that the image is cropped just after paste. I mean, it is cropped in the clipboard already...
HI,
You mean to say that you are not getting whole sheet image properly?
Exactly, I'm getting a partial image normally loosing the rightmost ot bottom part.
Hi,
Instead of printing the full screen you should think on either create a report, which keeps then all necessary contents in a structured way or to send bookmarks or you can directly go to file->print sheet option and check once the print preview
Hi
I don't want to make a PDF report cause is a mess working with complex objects.
I need a support to be able to check the data offline so If I don't want a PDF I need a PPT and I'm fingind this issue...