All:

I need to upgrade from XL2000 (VBA 6.3). Question I have is whether it's
worth going straight to XL2007 even thought most of my clients are using
XL2003. My primary concern is the apparent superior security that 2007
provides - I've been wary of the limited, 40-bit encryption that earlier
versions offer.

TIA,

Jim

"Art" wrote:

Bob,

Well, that's not good news. Thanks for the link -- I haven't spent much
time looking at it yet, but it seems interesting.

On a related topic... I've been trying somewhat succesfully to use VSTO --
Visual Studio is very nice and the functionality of a full version of VB.net
is really nice. BUT... it is really a pain to use sometimes and definitely
harder to deploy than a file with VBA in it. The Object Model is also not
nearly as easy as running directly in VBA in Excel. So I was sort of hoping
(without any real expectation of this happening) that perhaps the VBA
implementation might move a little in that direction in order to get the best
of both worlds.

Anyway, sorry about the semi-rant, but thanks again for the info.

"Bob Flanagan" wrote:

Art, I've noticed that the macro recorder in Excel 2007 records very little
with regard to shapes and charts. So one often doesn't get even a good
starting point.

I also have noticed that macros run noticably slower in Excel 2007.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Art" wrote in message
...
Hi,

I've yet to update to XL2007. Does anyone know of anything in particular
that's different with regard to programming in VBA?