![]() At this point, I don't want to get into any particulars of what methods I called in the script, but I'm looking for general feedback regarding the relative speeds of each technology, and what I might be able to do to speed up the AppleScripts. I tried running the AppleScript with the Excel file "hidden" (I clicked the yellow button on the window), and I also tried saving the script as an "Application", which I thought would speed things up, but didn't. I don't want to start any "religious" wars, but I'm curious as to whether AppleScript code is really that much slower than VBA code. ![]() The Mac that I ran the AppleScript on is a 867 Mhz PowerBook with 1.125 Gb of RAM running Excel 2008 under OS X 10.5.6, and the Windows machine I used is a 350 Mhz machine with 384 Mb of RAM running Excel 2002. I then wrote essentially the same code in VBA using Excel on a Windows machine, and this code ran in about 1 hour. ![]() I first attempted this in AppleScript, but it took a very long time to run for each file, maybe 3-5 hours. I recently had to process a few large (>30,000 rows) Excel files, parsing through them using the Find command, extracting selected pieces of data, and constructing a new worksheet with the extracted data.
0 Comments
Leave a Reply. |