Impoting photos7 in Excel VBA

[Sb]

Hello,

I almost completed my application, and I needto import some photos in the
document. It is about 20 photos, and I mamaged routine for selecting and
placing phots in the documnet. Problem is now that excel file is too big,
when photos are of 2-3 MB each, excel file becom 20 MB an more. That case
all starts to work very slowly, and colaps.

If there is solution, to have some VB command in to the code to reduce size
of the photo during importnitng. It is posible to compress photo in the
Exce, but don't know how to make same thing automated in the VB code.

Much appreciate if anyone could help me to resolve tihs problem.

Thanks,
Boro

 

[Gord Dibben]

Graphics have very little room to compress.

Why do your pictures have to be that size?

I would re-size them the same as I would do for emailing.

Drop them down to 100kb or so.

Use the PowerToy Image Resizer from this site.

http://www.microsoft.com/windowsxp/downloads/powertoys/xppowertoys.mspx

The average eye won't see the difference.

If for printing, that would be another matter.


Gord Dibben MS Excel MVP