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: Emile Schwarz <email@hidden>
- Date: Fri, 26 May 2006 18:07:22 +0200
email@hidden wrote:
Date: Thu, 25 May 2006 23:55:20 -0400
From: Sweth Chandramouli <email@hidden>
Subject: Re: Searching for cells/rows/columns in Excel
To: AppleScript <email@hidden>
Message-ID: <email@hidden>
Content-Type: text/plain; charset=us-ascii
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.
-- Sweth.
I know one other development environment (exists also for Windows, Linux
- thus not for excel -) who allows you to do what you want: REALbasic.
Home URL: <http://www.realbasic.com/>
Demo (for 15 days) exists, at: <http://www.realbasic.com/download/> -
needs a demo license number - you can ask one online after you boot the
demo version. (documentation, etc. available on the same page).
<http://www.realsoftware.com/realbasic/officeautomation/> will gives you
more infos on how to use REALbasic to automate Office documents - Excel
for example -.
At last, you can call AppleScripts from withing the REALbasic standalone
application (very simple).
NOTA: I am not related to REAL Software - the REALbasic owner- excepted
that I use this software.
HTH,
Emile
For your info, here's a quote of the Language Reference (exists in pdf,
see the download page to get it), Excel main related page.
<quote>
ExcelApplication Class
Used to automate Microsoft Excel.
Notes:
The language that you use to automate Microsoft Office applications is
documented by Microsoft and numerous third-party books on Visual Basic
for Applications (VBA). Microsoft Office applications provide online
help for VBA. This is your primary reference for REALbasic office
automation.
To access the online help, choose Macros from the Tools Menu of your MS
Office application, and then choose Visual Basic Editor from the Macros
submenu. When the Visual Basic editor appears, choose Microsoft Visual
Basic Help from the Help menu. The help is contextual in the sense that
it provides information on automating the Office application from which
you launched the Visual Basic editor.
If VBA Help does not appear, you will need to install the VBA help
files. On Windows Office 2003, Office prompts you to install the VBA
help files when you first request VBA help. You don't need the master
CD. On Macintosh, Office v.X does not install the VBA help files as part
of the full install. Quit out of Office and locate your master CD. Open
the "Value Pack" folder and double-click the Value Pack installer. In
the Value Pack installer dialog, scroll down to the Programmability
topic, select it, and click Continue. The installer will then add the
VBA help files and examples to your Office installation. When the
install finishes, the VBA help files will be available to the Visual
Basic editor within all your Office X applications.
Microsoft has additional information on VBA at
http://msdn.microsoft.com/vbasic/ and have published their own language
references on VBA. One of several third-party books on VBA is "VB & VBA
in a Nutshell: The Language" by Paul Lomax (ISBN: 1-56592-358-8).
</quote>
_______________________________________________
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