AJS
06-23-2008, 09:42 PM
Hi,
I have set up my database to display images stored elsewhere on my harddrive, using several fields to construct paths for the images. I'd like to write VBA that will copy the displayed image to the clipboard, but I have not been successful so far. The pertinent parts of my code are as follows. In my declared variables:
Dim MyDataObj As New DataObject
Dim strImagePath As String
where strImagePath is the full path for the image. Later on I try to get the image into the clipbard via:
Set MyDataObj = strImagePath
MyDataObj.PutInClipboard
With this approach I get a 424 error. Any other ideas?
Thanks, Aaron
I have set up my database to display images stored elsewhere on my harddrive, using several fields to construct paths for the images. I'd like to write VBA that will copy the displayed image to the clipboard, but I have not been successful so far. The pertinent parts of my code are as follows. In my declared variables:
Dim MyDataObj As New DataObject
Dim strImagePath As String
where strImagePath is the full path for the image. Later on I try to get the image into the clipbard via:
Set MyDataObj = strImagePath
MyDataObj.PutInClipboard
With this approach I get a 424 error. Any other ideas?
Thanks, Aaron