Range.CopyPicture question

[Gokhan Aycan]

Is there a limit on how many rows that can be copied or an image size limit? Or some other setting etc I need to check?

When the range is 6000 rows by 20 columns, the resulting image is around 1600 rows (just short of 25000 points).

Essentially using:

rng.CopyPicture xlScreen, xlPicture

rng2.PasteSpecial

xlPrinter is even less, 200ish rows (I guess Print Area comes into play here).
xlBitmap has worse resolution and file size impact is almost double.

 

[Dan_W]

When you try to put it on the VBA Userform directly, where is the code located? In the Userform itself? Also, what happens if you paused for a few seconds before trying to apply it to the Userform? I've observed some odd behavior with the VBA Userform when trying to do graphics-related the first few seconds after it loads.

 

[Gokhan Aycan]

Hmm, iirc code is on a standard module (should be mdlVideo). Did I try the waiting? Not with the code, but definitely using the Immediate window.

 

[Dan_W]

Hmm... what if you tried situating the video in a frame? Frames have hwnd properties too that you can access (though it isn't obvious).

 

[Dan_W]

Sorry, I would be checking this myself but I'm not near a computer atm.

 

[Gokhan Aycan]

Heh, no problem. I will check it myself too the next time I work on it. It seems I need to gather some more strength.