Applescript for getting data from a spreadsheet
bobs at twft.com
Fri Dec 9 20:15:02 EST 2011
Hey! That did the trick! Now how would anyone know that? Let's say I was the first person ever to begin working with Applescript. How would I have ever come up with that solution? But thank you. Now I can get on with my uber utility.
On Dec 9, 2011, at 4:35 PM, zryip theSlug wrote:
> On Sat, Dec 10, 2011 at 1:03 AM, Bob Sneidar <bobs at twft.com> wrote:
>>> The Excel documentation has numerous traps. Sometimes the syntax is
>>> natural and sometimes... surnatural. ;-)
>>> open workbook workbook file name "DHCP Clients.xlsx"
>>> Best regards,
>>> -Zryip TheSlug- wish you the best! 8)
>> 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"
> The problem should be in the unix path.
> set myPath to POSIX file "/Volumes/data/LogosAdmin/TechData/Tech
> Documents/DHCP Clients.xlsx"
> open workbook workbook file name myPath
> Best regards,
> -Zryip TheSlug- wish you the best! 8)
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode