Applescript for getting data from a spreadsheet

stephen barncard stephenREVOLUTION2 at barncard.com
Fri Dec 9 19:29:12 EST 2011


have you used

revUnixFromMacPath(*macPathname*[,*convertOSX*])


to clean up the pathname for AS?

On 9 December 2011 16:03, Bob Sneidar <bobs at twft.com> wrote:

> > 8-)
> >
> > The Excel documentation has numerous traps. Sometimes the syntax is
> > natural and sometimes... surnatural. ;-)
> >
> > Try:
> > open workbook workbook file name "DHCP Clients.xlsx"
> >
> >
> > Best regards,
> > --
> > -Zryip TheSlug- wish you the best! 8)
> > http://www.aslugontheroad.com
>
> I get: error "Microsoft Excel got an error: Can’t continue open workbook."
> number -1708
>
> By the way I know the path is correct.
>
> I tried with the full path:
> open workbook workbook file name "/Volumes/data/LogosAdmin/TechData/Tech
> Documents/DHCP Clients.xlsx"
>
> I tried the short name:
> open workbook workbook file name"DHCP Clients.xlsx"
>
> I tried setting the default path:
> set default file path to "/Volumes/data/LogosAdmin/TechData/Tech
> Documents/"
> open workbook workbook file name "DHCP Clients.xlsx"
>
> Thanks for trying zryip. This has reminded me why after great hopes that
> Applescript could replace Hypercard (in some sense), why I was driven to
> despair and went looking for some kind of hypercard-like software. That was
> when I found Revolution/Livecode. Applescripters are at the mercy of the
> people in the software developers employ concerning how they implement
> their dictionary, and how they document it. Places where enumeration makes
> all the sense in the world, you might find they didn't implement it. Places
> where a simple argument like the full path to a file, as in "open workbook"
> simple does not work like that, and there is NOTHING but NOTHING in the way
> of developer documentation to explain how the hell they want you to do
> things! That is insanity waiting to happen, and I am already crazy so there
> is no new ground to cover here.
>
> By the way, I know the path is correct. I copy/pasted it from the Get Info
> window.
>
> Bob
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 



Stephen Barncard
San Francisco Ca. USA

more about sqb  <http://www.google.com/profiles/sbarncar>



More information about the use-livecode mailing list