• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Converted VBA macros
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: Converted VBA macros
      • From: Shane Stanley <email@hidden>
  • Prev by Date: Re: InDesign Set Opacity Gone In CS3?
  • Next by Date: known applescript prevent sleep issues?
  • Previous by thread: Re: InDesign Set Opacity Gone In CS3?
  • Next by thread: Re: Converted VBA macros
  • Index(es):
    • Date
    • Thread