Menu

Copying images from Excel to Access

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.programming

wisaac

wisaac is offline

external usenet poster

Posts: 3

Default

Copying images from Excel to Access

(wisaac) wrote in message om...
I would like to automate the process of copying an image from Excel to
the clipboard, and pasting it into an OLE Object field in an Access
table.

I want to do something like:

Dim MySheet As Worksheet
Set MySheet = appX.Workbooks(Filename).Worksheets("Requirements" )
Dim pic As Shape
rsExcelImport.MoveFirst
For Each pic In MySheet.Shapes
pic.Copy
'Somehow paste to MS Access
rsExcelImport.MoveNext
Next pic

Any advice on how I can accomplish this?

It looks like the right way to do this is with a form.

Set frm = Forms!frmExcelImport
i = 1
For Each pic In MySheet.Shapes
pic.Copy
frm.GoToPage i
frm.Requirement.OLETypeAllowed = acOLEEmbedded
frm.Requirement.Class = ""
frm.Requirement.Action = acOLECreateEmbed
frm.Requirement.Action = acOLEPaste
i = i + 1
Next pic

I am hoping to get this code working, but I don't know what class to
use. I get an error stating "The item on the Clipboard can't be
pasted into this control." It is a bitmap that is being copied to the
clipboard. Anyone know what class to use?

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I customise quick access toolbar button images in Excel 200	Andie	Excel Discussion (Misc queries)	1	August 25th 07 12:08 PM
Copying Data from Access to Excel in a macro	GLS	Excel Worksheet Functions	2	November 15th 06 03:47 PM
Copying figures from Access to Excel	dalymjl	Excel Worksheet Functions	0	September 29th 06 05:49 PM
how i convert excel files with images to access	mike	Excel Discussion (Misc queries)	1	March 7th 05 05:51 PM
how i convert excel files with images to access	mike	Excel Discussion (Misc queries)	1	March 7th 05 03:11 AM

All times are GMT +1. The time now is 05:08 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement