Converted VBA macros
Converted VBA macros
- Subject: Converted VBA macros
- From: Raymond P Reedy <email@hidden>
- Date: Mon, 5 May 2008 16:19:02 -0400
I have converted a few of my VBA macros to AppleScript and have
tested them in Leopard using Office 2004 (Excel) and Office 2008
(Excel). An observation..
The scripts run extremely slow in Office 2008.
This particular snippet takes 13 seconds in (2004) and takes 1 minute
19 seconds in (2008), processing only 238 records.
set lastRowNumSorter to first row index of
¬ --Count records
(get end (cell 1 of row (count rows)) direction toward the top)
repeat with i from lastRowNumSorter to 2 by
-1 --Loop while deleting empty
if value of (cell 3 of row i) = "" then
delete entire row of (cell 3 of row i)
end if
end repeat
I also noted while testing that any user action on the worksheet
while the script is running (scrolling to observe) produces
unexpected results.
How can I "Lock out" the user while the script is running?
Ray
Raymond P Reedy
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden