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

Excel 2008: insert picture from file

 
   Macintosh computer (Home) -> Apple Scripts RSS
Next:  OS X Terminal and ports  
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: 1675



(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:
Microsoft Excel 2008 and Applescript - Hi, I have a sheet that contains data from column A to column N. Column O makes a sum of datas from column A to column N. When I add datas for some rows, I want my script to copy the sum in previous row to next row. The following script does the jo...

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...

new word 2008 applescript questions - hi, im stuck trying to create a script that adds data to a word document. im trying to figure out how to add spaces (ie similar to typing the return key) between things i insert into a doc as follows: -open document -advance the cursor down below the..

Question about replacing a Macro in Word 2008 with an Appl.. - Hello, Although I've had a Mac for a few years now, I've never delved into Apple script. I find myself needing to start from scratch to replace a Macro in Word 2008 (MS eliminated VBA from this new version of Office - that's another story for another..
   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 ]