Impoting photos7 in Excel VBA

  • Thread starter Thread starter Sb
  • Start date Start date
S

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
 
Back
Top