Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export Sheet as image not working propiertly

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

6 Replies
vijetas42
Specialist
Specialist

Hi,

may be you haven't set the parameters like
with PPSlide.Shapes.Paste

.Left  = 40

.Top   = 130

.Width = 100

.Height = 275

end with 

Not applicable
Author

The problem is that the image is cropped just after paste. I mean, it is cropped in the clipboard already...

vijetas42
Specialist
Specialist

HI,

You mean to say that you are not getting whole sheet image properly?

Not applicable
Author

Exactly, I'm getting a partial image normally loosing the rightmost ot bottom part.

vijetas42
Specialist
Specialist

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

Not applicable
Author

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