VBA, clipboard and bitmaps?

[Matt Kisasonak]

I am using this code in VB to save the contents of the
clipboard as an bitmap file. How can this be done with
VBA since DataObject only supports text?

'Save as picture
Dim ClipPic As New StdPicture
Set ClipPic = Clipboard.GetData()
strFileName = "C:\Program Files\temp.bmp"
SavePicture ClipPic, strFileName
Set ClipPic = Nothing

 

[Stephen Lebans]

Matt you asked this very same question on October 22. I replied a couple
of days later. Do you not understand how to configure your NG reader to
show "replies to your posts".

Finally do you know how to search GoogleGroups in Advanced mode?
http://groups.google.com/groups?as_q=Kisasonak&safe=images&as_ugroup=*ac
cess*&as_scoring=d&lr=&num=100&hl=en
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.