ACCESS 2003 Excel 2003 : VBA for opening Excel file from Access and copying a pictre from excel the

Posted by Justin on Stack Overflow See other posts from Stack Overflow or by Justin
Published on 2010-03-27T12:46:00Z Indexed on 2010/03/27 12:53 UTC
Read the original article Hit count: 298

Filed under:

ms-access

|

ms-access-2003

|

excel-vba

|

visual-basic

|

vba

So I have an excel workbook that has a nice global map of shaperange objects. With some very simple code I can change the colors, group and ungroup collections of countries into arrays, etc...and it works pretty well. However, I would like to bring this into Access.

So I could copy and paste all the shapes into an access form manually, but then they become pictures and I cannot change the colors of the countries (shaperange objects) to have the map act interactively as I can in excel.

So I am thinking that I know how to use excel functions from access, and how to open excel from access. Is there a way to copy an object from excel (I know the file name and the shape name that i mean to copy everytime), and bringing it back to access to paste on a form?

Atypical, I know, all my Access questions are. Thanks!

© Stack Overflow or respective owner

Related posts about ms-access

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

as seen on SQL Authority - Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and… >>> More
LINKED TABLES BETWEEN MS ACCESS 2003 AND MS ACCESS 2007-WRITE PERMISSIONS DENIED

as seen on Super User - Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files. In one case, the user has 2007 on his PC and opend the front end in 2007. No problems. When the the user is done, he clicks a button that executes a macro full of update queries. The macro… >>> More
Working with Compressed (zipped) folders in MS Access

as seen on Internet.com - Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application. >>> More
Extending the InputBox function for MS Access Forms

as seen on Internet.com - Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function. >>> More
Uses for Cartesian Products in MS Access

as seen on Internet.com - Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products. >>> More

Related posts about ms-access-2003

MS Access 2003 - ordering the string values for a chart not alphabetical

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is a silly question. Lets say I have a query that produces for a list box, and it produces values for three stores Store A 18 Store B 32 Store C 54 Now if I ORDER BY in the sql statement the only thing it will do is descending or ascending alphabetically but I want a certain order… >>> More
MS Access 2003 - Embedded Excel Spreadsheet on Access form

as seen on Stack Overflow - Search for 'Stack Overflow'
lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame ExcelFrame and I add a text box on the form called txtA1 and I add a button on the form called cmdInsert I want to type "Hello World" into the text box, click the button and have it appear in… >>> More
MS Access 2003 - Message Box: How can I answer "ok" automatically through code

as seen on Stack Overflow - Search for 'Stack Overflow'
So a couple silly questions: If I include this in some event: MsgBox " ", vbOkOnly, "This little message box" could I then with some more code turn around and 'click the ok button. So that basically the message boox automatically pops up, and then automatically goes away? I know its silly because… >>> More
MS Access 2003 - Format a Number with Commas AND Auto-Decimal

as seen on Super User - Search for 'Super User'
On a report I have a control which is bound to a column which can have up to 3 decimal places. I want the number to format with commas separating thousands and millions, but I also want the number of decimal places to be automatic, so that if there is no decimal portion then no decimal at all is… >>> More
MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I use functions like the following to make temporary tables out of crosstabs queries. Function SQL_Tester() Dim sql As String If DCount("*", "MSysObjects", "[Name]='tblTemp'") Then DoCmd.DeleteObject acTable, "tblTemp" End If sql = "SELECT * INTO tblTemp from TblMain;" Debug.Print (sql) … >>> More