View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default using VBA to insert a column of pictures

As written, this would raise an error, even disregarding the wordwrap
problem.

--
Regards,
Tom Ogilvy

"Charles " wrote in message
...
Andy,

Here is a code that you can work with. It's for a BMP. But it may give
you some ideal.

Charles


Sub Get_picture()
Dim fname
fname = ActiveCell.Offset(0, -1)
ActiveSheet.Pictures.Insert ( _
"C:\Documents and Settings\Charles Harmon\My Documents\My
Pictures\") & fname<<fname wksh =101.bmp
End Sub


---
Message posted from http://www.ExcelForum.com/