adding pictures to spreadsheet

K

Kilo Bravo

I have an excel VBA module which inserts some BMP files into a spreadsheet. I know there are better ways to this but this is how the boss wants it. anyway, it works good but suddenly the BMP files are sized small. I mean it used insert the BMP files at their full size. The critical line of code is:

activesheet.pictures.insert(pathname & filename)

There is no size attribute involved here.

Any ideas out there? Is there a better way to code it?



--
K.Brown
/*****************************************************************************
To the optimist, the glass is half full.
To the pessimist, the glass is half empty.
To the engineer, the glass is twice as big as it needs to be.
******************************************************************************/
 
D

Doug Robbins

Better to ask in the Excel Programming newsgroup. This one is for Word.

--
Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis.

Hope this helps,
Doug Robbins - Word MVP
I have an excel VBA module which inserts some BMP files into a spreadsheet. I know there are better ways to this but this is how the boss wants it. anyway, it works good but suddenly the BMP files are sized small. I mean it used insert the BMP files at their full size. The critical line of code is:

activesheet.pictures.insert(pathname & filename)

There is no size attribute involved here.

Any ideas out there? Is there a better way to code it?



--
K.Brown
/*****************************************************************************
To the optimist, the glass is half full.
To the pessimist, the glass is half empty.
To the engineer, the glass is twice as big as it needs to be.
******************************************************************************/
 
Top