Can anyone recommend a good book on Advanced Excel (VBA) and basicprogramming for Macs?

[Dave]

Hello,

I am a new Mac user with no programming experience but would like to
be more proficient in Mac programming. I work in finance and would
like to develop an integrated trading platform that can download
historical price data automatically and then manipulate the data via
Visual Basic, macros, etc.

I'd appreciate any assistance on how to get started.

Thanks,

Dave

 

[peterthebag]

Hi,
if you want to use VBA you need office 2004 as MS ripped VBA out of
office 2008
You are probably better off looking at applescript. Good links are:

http://www.microsoft.com/mac/developers/default.mspx
http://macscripter.net/

Macscripter has a lot of useful inforation - including a beginners
guide, free scripts etc.

This:

http://groups.google.com/group/alt.comp.lang.applescript/topics?lnk=srg

may also be of use.

Alternatively Neo office ( a mac version of open office ) or Open
office (aqua version this is still in alpha, so you may prefer the
version that requires X11 to run) are highly scriptable in Basic and
Python, as well as some other language (javascript? - i forget).

http://www.neooffice.org/neojava/en/index.php

http://porting.openoffice.org/mac/download/aqua.html

Open office is cross platform and Free.

A google search will no doubt reveal many other useful sites.

Best of luck.
PtB

 

[Bob Greenblatt]

Hello,

I am a new Mac user with no programming experience but would like to
be more proficient in Mac programming. I work in finance and would
like to develop an integrated trading platform that can download
historical price data automatically and then manipulate the data via
Visual Basic, macros, etc.

I'd appreciate any assistance on how to get started.

Thanks,

Dave

If you are using Office 2004, any of the many books covering VBA will
suffice. There are indeed some minor differences between Mac VBA and
Windows, but for the most part everything will work the same way. If you
have any trouble, ask here and we'll help sort it out.

If you are using Office 2008, I'm afraid you are out of luck. Office 2008
does not support VBA.