Other References for VBA on Mac OS X?

[Debi]

Does VBA on Mac OS X have any References (object/type libraries) other
than the default ones supplied with the Office X installation? And if
so, where/how does one obtain them?

-- Debi

 

[Paul Berkowitz]

Does VBA on Mac OS X have any References (object/type libraries) other
than the default ones supplied with the Office X installation? And if
so, where/how does one obtain them?

There's no VBA specific to a particular Mac OS. It's specific to the version
of Office Mac you have. But it must have been tweaked very, very slightly
for Office v. X to accommodate a few small differences of IS X. Otherwise
the version of VBA Machas been the same for many versions: It's VBA 5.0 in
Office 98, 2001 and X. There are a very few Mac-only methods, properties and
arguments, and more Win-only methods, properties and arguments. They are
always spelled out clearly in the VB Editor Help (even in Windows!), which
is really the best place to learn about them.

Putting aside the few Mac-specific items, the VB Editor Help is still a good
place to learn about specific Objects, Methods and Properties. But to get a
good grasp of the language as a whole, you _could_ get he official
multi-volume sets of Visual Basic for Applications 5.0 published by
Microsoft Press. I think there are separate books for Wor,d Excel and PPT.
Personally, however, I would recommend the books published by O'Reilly as
simpler, clear tutorials. I particular I'd recommend "Writing Word Macros"
by Steven Roman, published by O'Reilly. (It used to be called "Learning Word
Programming".) It's outstanding.

You can also learn lots and lots at the Word MVP website. You have to go
there in Internet Explorer, you get blank pages in Safari.

http://word.mvps.org/
http://word.mvps.org/Tutorials/index.htm

--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: <http://www.entourage.mvps.org/toc.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Entourage you are using - 2001 or X.
It's often impossible to answer your questions otherwise.

 

[Debi]

Thanks for the info, Paul, but I wasn't looking for references about
VBA, I was talking about the References that you can access when you
go to the menu item Tools: References.

My install of Office X shows the following:

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Forms 2.0 Object Library
Microsoft Office 10.0 Object Library
Microsoft Graph 10.0 Object Library
Microsoft PowerPoint 10.0 Object Library
Microsoft Visual Basic for Applications for Extensibility
Microsoft Word 10.0 Object Library
VBA Converter

I was wondering if there are other Object Libraries available on Mac
OS X, and if so, how one gets them. For example, on a Windows machine
with Acrobat installed, there are some extra libraries for Acrobat and
Distiller.

-- Debi

 

[JE McGimpsey]

Thanks for the info, Paul, but I wasn't looking for references about
VBA, I was talking about the References that you can access when you
go to the menu item Tools: References.

My install of Office X shows the following:

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Forms 2.0 Object Library
Microsoft Office 10.0 Object Library
Microsoft Graph 10.0 Object Library
Microsoft PowerPoint 10.0 Object Library
Microsoft Visual Basic for Applications for Extensibility
Microsoft Word 10.0 Object Library
VBA Converter

I was wondering if there are other Object Libraries available on Mac
OS X, and if so, how one gets them. For example, on a Windows machine
with Acrobat installed, there are some extra libraries for Acrobat and
Distiller.

AFAIK, there are no Mac Applications other than Office that support VBA.

 

[Jim Gordon MVP]

Hi Debi,

VBA on the Mac supports several types of references files. This is explained
in VBA's Help:

"References Command (Tools Menu)
See Also Specifics
Displays the References dialog box. This dialog box allows you to add an
object library or type library reference to your project. This makes another
application's objects available in your code. Once a reference is set, the
referenced objects are displayed in the Object Browser.
You can also add references to other loaded and saved projects. If a project
has not been saved, it appears as "UNSAVED: <ProjectName>" and you will be
unable to make a reference to it.
Only available at design time."

Developers can make references to
€ Type Libraries (*.olb, *.tlb, *.dll)
€ Shared Libraries

Where to get more? Get them from other developers or make them yourself.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.