Re: Searching for cells/rows/columns in Excel
Re: Searching for cells/rows/columns in Excel
- Subject: Re: Searching for cells/rows/columns in Excel
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 25 May 2006 21:10:25 -0700
- Thread-topic: Searching for cells/rows/columns in Excel
On 5/25/06 8:55 PM, "Sweth Chandramouli" <email@hidden>
wrote:
> On Thursday, 25 May 2006 at 05:41:04 EDT,
> David Wignall (<email@hidden>) wrote:
>> A) What version of Excel? 2004 has a very different Applescript
>> implementation
>
> 2004.
>
>> B) Does it have to be Applescript? Could it be VBA or a worksheet method?
>
> No requirement to be Applescript, but I was unaware that you could use
> VBA on Macs. If VBA is the better solution, though, then perhaps people
> could email me suggestions off-list so as to avoid another round of the
> "this isn't a generic Mac scripting list" debate. :) I'm open to
> whatever gets me easiest access to the data, though.
VBA works fine, but will be discontinued in some future version. If you have
a working VBA macro for Excel Windows, try it out on the Mac. It will work
as long as you are not trying to use ActiveX controls or (rare) items that
only exist on VB 6 rather than VBA 5. (In a nutshell, if it works on Excel
97, it will work on excel Mac). Tools/Macros/Visual Basic Editor/Help will
give you a lot of what you need to know.
If you have Office 2004, you are much better off using AppleScript, which
will be supported "forever". It mirrors almost exactly the VBA model (they
_both_ hook into a lower-level implementation called OLE Automation). To
learn about how the AppleScript implementation version works, download the
Excel AppleScript Reference Guide from http://www.microsoft.com/mac/ , click
links to Resources/Developer/AppleScript. it's a 500-page book....
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden