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