Very cool! I guess what I was doing wrong before is that I was not specifying the sheet and workbook name. It kept saying in it's cryptic way that it didn't understand the copy range command. <sigh> Applescript. I love it. I hate it.
Bob On Dec 9, 2011, at 12:54 PM, zryip theSlug wrote: > On Fri, Dec 9, 2011 at 9:06 PM, Bob Sneidar <[email protected]> wrote: >> Thanks man! Can I come sit at you feet and learn of your greatness?? ;-) >> Seems though that Excel locked up. It works for small selections, but Excel >> didn't like it when I did that for 4 columns of 4000+ rows. Also, I wonder >> if referencing entire columns might try to get all the data in all the >> *possible* rows instead of all the rows that have data in them? That is why >> I was trying to get Excel to actually SELECT the columns and then copy them >> to the clipboard. >> >> Maybe I should move my Excel data to a Livecode stack. Hmmm... > > No need to select the columns, you can copy them directly in the clipboard. > > An example for copying columns A to D: > > tell application "Microsoft Excel" > activate > COPY RANGE range "A:D" of sheet "mySheet" of workbook "myWorkBook" > end tell > > Note that the command is named COPY RANGE, so don't forget to repeat > the word "Range" two times. > > Maybe you will be happy to know, I'm actually working on an Excel > Library for Livecode. > The library will covered the following topics: > > - Excel Application > - Window > - Workbook > - Sheet > - Range > - Chart > - Shape > - Printing > > The library will come for mac and windows. > > > Best regards, > -- > -Zryip TheSlug- wish you the best! 8) > http://www.aslugontheroad.com > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
