M
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 be very 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?
Would you share with me what you got so far about programming in Office 12?
What I mentioned here is what I have up to now. It is all too interesting to
ignore.
Shafiee.
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 be very 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?
Would you share with me what you got so far about programming in Office 12?
What I mentioned here is what I have up to now. It is all too interesting to
ignore.
Shafiee.