Welcome to MacBoardz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Excel 2008: insert picture from file

 
   Macintosh computer (Home) -> Apple Scripts RSS
Next:  Firewall, enterprise solution?  
Author Message
iGods

External


Since: Apr 19, 2010
Posts: 1



(Msg. 1) Posted: Mon Apr 19, 2010 4:10 pm
Post subject: Excel 2008: insert picture from file
Archived from groups: alt>comp>microsoft>office, others (more info?)

Hello Scripters, had a real head scratcher here that I was hoping
someone could help me with.

I'm trying to script picture replacements in an Excel 2008
spreadsheet.The images ogitinal exist in the spreadsheet, and the
replacements are sitting in a folder next to the document.

I cannot figure out how to do either a Change Picture or Insert
Picture/From File within Applescript.

I did come across the ability to throw up an Insert Picture/From File *dialog*:

tell application "Microsoft Excel"
show (get dialog dialog insert picture)
end tell

.... but, I don't want the dialog, I want the script to avoid the dialog
altogether. Oddly, there doesn't seem to be a "dialog insert picture"
constant... or a Change Picture menu item for that matter (the "Change
Picture" command appears to be available only from the Contextual Menu).

Even if I *did* choose to do it via UI Scripting, there doesn''t even a
seem to be a way to get the result of the show (get dialog dialog
insert picture) command.

One has to wonder just what drugs Microsoft was on when they missed
this in their otherwise very extensive Applescript dictionary.

Anyway, has anyone gotten around this, or perhaps someone could pass
along their strategy for updating images? I *cannot* use OLE image
linking, since the document I'm working on has been cloned from a
different project, and any OLE links would be associated with the
original client, not the intended one.

Any help would be massively appreciated. Thanks to all.

 >> Stay informed about: Excel 2008: insert picture from file 
Back to top
Login to vote
Dave Balderstone

External


Since: Mar 21, 2006
Posts: 1688



(Msg. 2) Posted: Mon Apr 19, 2010 5:48 pm
Post subject: Re: Excel 2008: insert picture from file [Login to view extended thread Info.]
Imported from groups: alt>comp>microsoft>office, others (more info?)

This message is not archived

 >> Stay informed about: Excel 2008: insert picture from file 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Scripting Excel - Avoid 2008 - I have two scripts I use in Excel regularly. One: Excel 2004 - 18 seconds Excel 2008 - 140 seconds Two: Excel 2004 - 55 seconds Excel 2008 - 334 seconds Bleah. -- Woodworking links and more at http://www.woodenwabbits.com -------------- I kill all..

How can i give a picture/text box an unique id or name???? - hi, Iam working with 1 master document on 6 pages. The problem is when i am changing picturebox 3 on the masterdocument in red, the wrong boxes are changing on the 6 other pages. There must be a way to give picture and textboxes unique names or id's so...

Setting desktop picture - The following script seems to compile and run properly, with no errors, but nothing happens -- the desktop picture is not changed. set ThePicture to choose file tell application "Finder" <font color=purple> ; set desktop picture...

"Insert" script for BBEdit 7.1 - Hello, I want to write a script for BBEdit 7.1 using the command "insert" from the "edit" menu. The purpose is to insert selected files in one open file. But when recording from the "record" menu doesn't give any result. Lo...

Word 2008 Script - hi, i have a script that i wrote a few years ago that takes information from a filemaker database and inserts it into a word document. this script was written before Word had any kind of redeeming applescipt dictionary and included VBA. bascially, the....
   Macintosh computer (Home) -> Apple Scripts All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]