Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Impoting photos7 in Excel VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sb - 04 Apr 2008 22:25 GMT
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 - 04 Apr 2008 23:33 GMT
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

>Hello,
>
[quoted text clipped - 12 lines]
>Thanks,
>Boro

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.