Re: Excel 11.0
Re: Excel 11.0
- Subject: Re: Excel 11.0
- From: Olivier Berquin <email@hidden>
- Date: Fri, 28 Oct 2005 09:35:41 +0200
Le 27-oct.-05 à 15:24, Mark J. Reed a écrit :
On 10/27/05, Olivier Berquin <email@hidden> wrote:
Yes, you're right. I never seen the difference between "formula" and
"value" because my tables (in excel) have only numbers or text, never
formulas.
Huh. I'm curious - what do you get out of using Excel for them,
if you're not doing any calculations?
I'm working every day with Adobe Indesign.
When I've a table in Indesign and my client send me an updated table,
I must copy-paste every cells of the Excel table in Indesign.
So, i've find this script to update a table in an InDesign document
from Excel.
Just select the same numbers of cell in Indesign and Excel and
"launch" the script...
--
tell application "Microsoft Excel"
set x to value of selection
-- convert list of lists to single list
set oldDelims to AppleScript's text item delimiters
set AppleScript's text item delimiters to {"&˘ˇ˜"}
set x to x as string
set x to text items of x
set AppleScript's text item delimiters to oldDelims
end tell
tell application "InDesign CS"
set contents of selection to x
end tell
--
Oli.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden