adding picture to worksheet

  • Thread starter Thread starter Kilo Bravo
  • Start date Start date
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.
******************************************************************************/
 
Try the AddPicture method of the Shapes Collection:

expression.AddPicture(FileName, LinkToFile, SaveWithDocument, Left, Top,
Width, Height)

--
Regards,
Tom Ogilvy


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.
****************************************************************************
**/
 
Back
Top