VBA in Office 12

[Mohamed Shafiee]

Hi,

I recently looked at a beta release of Office 2007, and found the interface
very appealing. However, I found out that it doesn't have VBA anymore. I use
VBA a lot to automate tasks which would otherwise would be repititive. This
was a major frustration.

But later on, after searching the internet about Office 2007, I learned
about the new file format called Open XML which includes new filename
extensions .docx, .xlsx, and .pptx I think... which is an XML based format
to store Office documents. If you rename the file by replacing the .docx or
..xlsx extension with .zip, it is a zip file which you can open. You can also
play with Office 12 files from within VB.net by using the namespace
system.IO.packaging or something... and this opens a new range of
possibilities for me, for generating office documents. This is a good thing.
But, still, you have to be able to access external applications through
office events. So VBA is a necessity.

So I was just wondering about it, and thought that I should ask you people.
I better be prepared for Office 12 before it starts to be widely used. Am I
right?

Shafiee.

 

[Patrick Schmid [MVP]]

Let me venture a guess. You are concluding that it doesn't have VBA,
because you couldn't find VBA anywhere on the ribbon? In that case, go
into Office button menu, Options, Popular and switch on the Developer
tab (you only need to do this in one program, e.g. Word to see its
effect in all). Then go on the Developer tab and press the VBA button.
Office 2007 still has VBA, just the button to get to it is hidden by
default.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[Shafiee]

Thanks Patrick....
So what do you know about this Open XML?

Let me venture a guess. You are concluding that it doesn't have VBA,
because you couldn't find VBA anywhere on the ribbon? In that case, go
into Office button menu, Options, Popular and switch on the Developer
tab (you only need to do this in one program, e.g. Word to see its
effect in all). Then go on the Developer tab and press the VBA button.
Office 2007 still has VBA, just the button to get to it is hidden by
default.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
Office 2007 Beta 2 Technical Refresh (B2TR):
http://pschmid.net/blog/2006/09/18/43
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Hi,

I recently looked at a beta release of Office 2007, and found the interface
very appealing. However, I found out that it doesn't have VBA anymore. I use
VBA a lot to automate tasks which would otherwise would be repititive. This
was a major frustration.

But later on, after searching the internet about Office 2007, I learned
about the new file format called Open XML which includes new filename
extensions .docx, .xlsx, and .pptx I think... which is an XML based format
to store Office documents. If you rename the file by replacing the .docx or
.xlsx extension with .zip, it is a zip file which you can open. You can also
play with Office 12 files from within VB.net by using the namespace
system.IO.packaging or something... and this opens a new range of
possibilities for me, for generating office documents. This is a good thing.
But, still, you have to be able to access external applications through
office events. So VBA is a necessity.

So I was just wondering about it, and thought that I should ask you people.
I better be prepared for Office 12 before it starts to be widely used. Am I
right?

Shafiee.