Printable View
Hi all,
I've created a few form that have many, albeit small, images (about 15 per form)... I have 2 problems with these forms. First off they take a very long time to load ... and they also make my actual .xls file huge (I'm up to 92mb as of right now).
Is there a way to make these image files smaller or more efficient? Most of the time, the actual resolution of these images doesn't really matter... Would lowering the resolution help?
Thanks
Hi
Few months back, I faced the same problems. I solved it by the following method.
1) Use Gifs instead of JPEG or BMP
2) Never Store the pic files in Excel. Always link the files on the form.
Just try these methods...
If the problem still persists then we will probe a litle bit further :)
Awesome! Thanks for the help..
If I change the Picture property of the Image class to an outside directory, is that considered linking? Or do I need to link the image through code during run time?
I'll convert to .GIF though.. Thanks again!
Yes that is linking.Quote:
Awesome! Thanks for the help..
If I change the Picture property of the Image class to an outside directory, is that considered linking?
You can also do it thru code if necessary. Avoid it if it is not necessary ;)
Hah.. Sounds good.. Was hoping to avoid that.
cheers!
Glad to be of help...Quote:
Originally Posted by pgag45
Just let us know if you were able to reduce the file size...
Yup.. changing to the GIF and removing some unnecessary images sufficiently reduced the size of the file..
thanks for the help!