Hi,

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

"Art" wrote

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

The main one I've noticed is that objects seem to behave differently.

"teepee" wrote in message
...

"Art" wrote

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

The main one I've noticed is that objects seem to behave differently.


In what way?

FileSearch is gone.

There is a CountLarge property to allow for the 1M rows.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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?

teepee,

Thanks -- in addition to new properties (like the countlarge that you
mention) have you run into any new problems?


"teepee" wrote:


"Art" wrote

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

The main one I've noticed is that objects seem to behave differently.

As I said FileSearch is gone, so that may be a big problem.

Also, the ribbon is obviously different to commandars, and have to be
created differently, unless you are happy that they end up on the Addins
tab.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Art" wrote in message
...
teepee,

Thanks -- in addition to new properties (like the countlarge that you
mention) have you run into any new problems?


"teepee" wrote:


"Art" wrote

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

The main one I've noticed is that objects seem to behave differently.

"Art" wrote in message
...
teepee,

Thanks -- in addition to new properties (like the countlarge that you
mention) have you run into any new problems?

Can't protect sheets and then allow users to edit those objects via VBA.

Can't alter certain characteristics of certain objects - eg with a graph you
can change the colour but not the border.

teepee,

Thanks very much. It will be a few months before I upgrade -- I guess I'll
look forward to it.

"teepee" wrote:


"Art" wrote in message
...
teepee,

Thanks -- in addition to new properties (like the countlarge that you
mention) have you run into any new problems?

Can't protect sheets and then allow users to edit those objects via VBA.

Can't alter certain characteristics of certain objects - eg with a graph you
can change the colour but not the border.

Bob,

Thanks for the info.

"Bob Phillips" wrote:

As I said FileSearch is gone, so that may be a big problem.

Also, the ribbon is obviously different to commandars, and have to be
created differently, unless you are happy that they end up on the Addins
tab.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Art" wrote in message
...
teepee,

Thanks -- in addition to new properties (like the countlarge that you
mention) have you run into any new problems?


"teepee" wrote:


"Art" wrote

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

The main one I've noticed is that objects seem to behave differently.

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?

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?