Copying a picture from excel to Access

wisaac

What I would like to do is automate the manual process of copying an
image from an excel spreadsheet to the clipboard, and pasting it into
an access table with an OLE Object field.

I want to do something like

rsExcelImport.MoveFirst
For Each pic In MySheet.Shapes
pic.Copy
'Paste to current record
rsExcelImport.MoveNext
Next pic

Any advice on how I can accomplish this?

Nov 12 '05 #1

Subscribe Post Reply

4018

wisaac

wi****@operamail.com (wisaac) wrote in message news:<db**************************@posting.google. com>...

What I would like to do is automate the manual process of copying an
image from an excel spreadsheet to the clipboard, and pasting it into
an access table with an OLE Object field.

I want to do something like

rsExcelImport.MoveFirst
For Each pic In MySheet.Shapes
pic.Copy
'Paste to current record
rsExcelImport.MoveNext
Next pic

Any advice on how I can accomplish this?

I'm not having much luck with this so far. I have an excel
spreadsheet with several pictures in it. I want to copy these
pictures to an MS Access table with an OLE Object field. If I can
copy and paste it in with a VBA script, that would be ideal, but if
there's another way to do it, please let me know.

Nov 12 '05 #2

wisaac

wi****@operamail.com (wisaac) wrote in message news:<db**************************@posting.google. com>...

What I would like to do is automate the manual process of copying an
image from an excel spreadsheet to the clipboard, and pasting it into
an access table with an OLE Object field.

I want to do something like

rsExcelImport.MoveFirst
For Each pic In MySheet.Shapes
pic.Copy
'Paste to current record
rsExcelImport.MoveNext
Next pic

Any advice on how I can accomplish this?

Nov 12 '05 #3

Similar topics

Automating picture linking

by: ColinWard | last post by:

Hello again. I am trying to figure out how to link a picture to a record from code. I have figured out how to get the proper dialogue box to open but I still have to manually check off the Link...

Microsoft Access / VBA

Copying a picture from excel to Access

by: wisaac | last post by:

What I would like to do is automate the manual process of copying an image from an excel spreadsheet to the clipboard, and pasting it into an access table with an OLE Object field. I want to do...

Microsoft Access / VBA

Copying A Picture From An OLE Object On A Form To A File

by: Steve | last post by:

Hi Can anyone tell me if it is possible to save a picture stored in an OLE objects on a form (bound object frame / unbound object frame) to a file. I have seen a command SavePicture Picture as...

Microsoft Access / VBA

Drag and drop a re-sized picture from excel to a picture box.

by: John P. Greiner | last post by:

I am trying to drag and drop a re-sized picture from excel to my application. I can implement the drag and drop and it works fine if a user drops a picture file, but the picture when dragged from...

C# / C Sharp

Copying pictures in Excel2000

by: mjwoods_2002 | last post by:

Hi, i am using C# to automate excel. i am trying to create a sheet of thumbnail images which i create in one worksheet and copy to another sheet. in vb.NET the code looks like this: ' copy the...

C# / C Sharp

Help needed on picture files in access

by: Gamesetal | last post by:

I need to include a picture / photograph in a Db then from a query export to Excel - picture included - I just can't find a way through this - can anyone please help? TIA JOhn

Microsoft Access / VBA

Copying and pasting information from excel to access

by: oli insight | last post by:

I have an excel spreadsheet with 500 rows of information. I want to copy and paste that information into an access table that i'm using, column by column.... But access only lets me copy and paste...

Microsoft Access / VBA

insert picture from MS access into MS excel

by: monadel | last post by:

I have a problem insering a picture into excel spread sheet from access. What I am trying to do is when user press a button it will create a excel spread sheet with picture on cell A(1,1) Can...

Microsoft Access / VBA

Access VBA to insert picture in excel spreadsheet

by: JFKJr | last post by:

Hello everyone, I am trying to insert a picture in an excel spreadsheet cell using Access VBA. The following excel VBA code is working perfectly fine and I am able to insert picture in "A1" cell....

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice