Hi all,

I was wondering if anyone knew whether VBA would be supported in Excel
Office 12??
and also would the object models be the same?
how would the XML format for save files affect everything?

Thanks heaps,
Jason

Jason,
A quick Google on [Office 12 VBA] gives you a good start, but briefly:
Yes.
No exactly, it is a new version after all.
See http://blogs.msdn.com/brian_jones/ar...12/438262.aspx

NickHK

"spIky haIred" wrote in message
oups.com...
Hi all,

I was wondering if anyone knew whether VBA would be supported in Excel
Office 12??
and also would the object models be the same?
how would the XML format for save files affect everything?

Thanks heaps,
Jason

Much of the Excel object model will remain, worksheets, workbooks etc., but
much will change to accommodate the new features, such as the ribbon. It
will be interesting to see how much of the old code works, and how much
doesn't.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"spIky haIred" wrote in message
oups.com...
Hi all,

I was wondering if anyone knew whether VBA would be supported in Excel
Office 12??
and also would the object models be the same?
how would the XML format for save files affect everything?

Thanks heaps,
Jason

Thanks Bob and Nick for your replies. Yes it will be interesting to see
how much of the old code works... it is something which I am a little
concerned about. Would this mean that if supporting older versions I
would need to write separate code (in some cases where the object model
has changed) for Office 12 and for Office 11 and earlier?

Bob Phillips wrote:

Much of the Excel object model will remain, worksheets, workbooks etc., but
much will change to accommodate the new features, such as the ribbon. It
will be interesting to see how much of the old code works, and how much
doesn't.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"spIky haIred" wrote in message
oups.com...
Hi all,

I was wondering if anyone knew whether VBA would be supported in Excel
Office 12??
and also would the object models be the same?
how would the XML format for save files affect everything?

Thanks heaps,
Jason

Jason,
It's generally best to write your code on the oldest version you expect to
support.
Backwards compatibility that is "usually" honoured in newer versions ensures
your code still works.

If you need some functionality that only exists in newer versions, you will
need to check which version the code is running on and take appropriate
steps.

NickHK

"spIky haIred" wrote in message
oups.com...
Thanks Bob and Nick for your replies. Yes it will be interesting to see
how much of the old code works... it is something which I am a little
concerned about. Would this mean that if supporting older versions I
would need to write separate code (in some cases where the object model
has changed) for Office 12 and for Office 11 and earlier?

Bob Phillips wrote:

Much of the Excel object model will remain, worksheets, workbooks etc.,
but
much will change to accommodate the new features, such as the ribbon. It
will be interesting to see how much of the old code works, and how much
doesn't.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"spIky haIred" wrote in message
oups.com...
Hi all,

I was wondering if anyone knew whether VBA would be supported in Excel
Office 12??
and also would the object models be the same?
how would the XML format for save files affect everything?

Thanks heaps,
Jason

I think the answer to that is that it is very likely that you will have to.
Backwards compatibility is fine, but as I see it the ribbon is so different
to commandbars that code that sets commandbars etc. just won't work.There is
conditional compiling though which eases the job.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"spIky haIred" wrote in message
oups.com...
Thanks Bob and Nick for your replies. Yes it will be interesting to see
how much of the old code works... it is something which I am a little
concerned about. Would this mean that if supporting older versions I
would need to write separate code (in some cases where the object model
has changed) for Office 12 and for Office 11 and earlier?

Bob Phillips wrote:

Much of the Excel object model will remain, worksheets, workbooks etc.,
but
much will change to accommodate the new features, such as the ribbon. It
will be interesting to see how much of the old code works, and how much
doesn't.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"spIky haIred" wrote in message
oups.com...
Hi all,

I was wondering if anyone knew whether VBA would be supported in Excel
Office 12??
and also would the object models be the same?
how would the XML format for save files affect everything?

Thanks heaps,
Jason

Hi again Bob and Nick,
Thanks again for your help on this topic. I think it will be
interesting for all VBA developers once the new Office 12 is released.
When are Microsoft anticipating it will be released? Also I don't know
much about the ribbon but is that the "command bar" that will be
replacing the old one? I agree with you there Bob, I think much of the
code there will change. Can I ask what "conditional compiling" is? I
was thinking of handling command bar related code with a check on which
version of Excel the user was running and executing the relevant block
of code accordingly... What kind of applications do both of you
develop?
Cheers :)

I was also considering to download the Office 12 beta... have either of
you done that to have a play around? I wonder if it would be
worthwhile? Thanks again guys.

"spIky haIred" wrote in message
ups.com...
Hi again Bob and Nick,
Thanks again for your help on this topic. I think it will be
interesting for all VBA developers once the new Office 12 is released.
When are Microsoft anticipating it will be released?

It certainly will be! AFAIK, MS are anticipating late 2006 but they still
have much testing to do yet, and so no date has yet been announced.

Also I don't know
much about the ribbon but is that the "command bar" that will be
replacing the old one? I agree with you there Bob, I think much of the
code there will change.

You can read about it on Jensen's blog at
http://blogs.msdn.com/jensenh/archiv...17/493890.aspx

Can I ask what "conditional compiling" is? I
was thinking of handling command bar related code with a check on which
version of Excel the user was running and executing the relevant block
of code accordingly...

Conditional compiling is where you create different code for multiple
situations, such as multiple versions, where you want the code to behave
differently in one situation to another. For instance, very simplistically,

#IF Ver12 Then
myVar = "this is running in Office 12"
#Else
myVar = "this is running pre-Office 12"
#End If

where Ver12 is a conditional variable that can either be defined in your
code declaratives, like this

#Const Ver12 = True 'False when compiling for pre-Office 12

or set in the project properties.

It is very useful, as the code than is it the True conditiojn is compiled,
the rest is ignored.

What kind of applications do both of you
develop?

I develop all sorts of apps, from stand-alone spreadsheets, to full apps,
using VBA, VB, Access, SQL-Server, ASP, etc.