J
Jane Parker
I have a series of Macros that goes through various Office documents and
automatically changes company trademark names to appear in the corporate
standard font and style. I am trying to get this working in Office 2007 and
having major problems.
I am becoming more and more frustrated with Office 2007. Microsoft seems
intent on eliminating VBA and forcing people to .NET only tools and having
to buy (and learn) Visual Studio.
In Word I can manually add the macro to the Quick Action Tool Bar but it
refuses to let me use a custom button face so it has a happy face or an
arrow. I see no way to add it to ribbon (for example to the add-ins tab)
without extensive XML coding. This coding is so difficult that Microsoft
provides a 'validation' tool that (like SQL) tells you if the code is good
or bad and little else. Otherwise, the only feedback you get is no response
when you try and evoke the XML code if it is not perfect. The 'example' of
how to code the XML is more than three pages of 10 point XML and assumes you
are already expert in XMP coding. I need what I had in 2003 where a user
would click on a button and the VBA code would install the macro and a
button.
In Outlook, things are even worse. It lets me manually paste the proper
face, but only on the old command bar that is on the screen with the in-box.
In a message (where I need it) there is only the ribbon and the XML problem.
More importantly, 2007 eliminates the HTML editor and replaces it with a
badly stripped subset of Word. It generates tons of garbage code using
Microsoft style sheets only available over the web. The normal thing is to
set it to strip out unnecessary code that does away with some unused
imbedded styles. [Please don't ask me why they imbed scores of styles when
using style sheets!] This also seems to strip out my </span> close span
statement and lose all the text until they use a span statement. I do not
yet see how to deal with that, even by unchecking the 'reduce size' box.
When I try and open my 2003 Install workbook, it simple deletes all of the
sheets. I have not even looked at PowerPoint yet.
Has anyone uncovered the secret of getting this sort of thing working with
Office 2007?
automatically changes company trademark names to appear in the corporate
standard font and style. I am trying to get this working in Office 2007 and
having major problems.
I am becoming more and more frustrated with Office 2007. Microsoft seems
intent on eliminating VBA and forcing people to .NET only tools and having
to buy (and learn) Visual Studio.
In Word I can manually add the macro to the Quick Action Tool Bar but it
refuses to let me use a custom button face so it has a happy face or an
arrow. I see no way to add it to ribbon (for example to the add-ins tab)
without extensive XML coding. This coding is so difficult that Microsoft
provides a 'validation' tool that (like SQL) tells you if the code is good
or bad and little else. Otherwise, the only feedback you get is no response
when you try and evoke the XML code if it is not perfect. The 'example' of
how to code the XML is more than three pages of 10 point XML and assumes you
are already expert in XMP coding. I need what I had in 2003 where a user
would click on a button and the VBA code would install the macro and a
button.
In Outlook, things are even worse. It lets me manually paste the proper
face, but only on the old command bar that is on the screen with the in-box.
In a message (where I need it) there is only the ribbon and the XML problem.
More importantly, 2007 eliminates the HTML editor and replaces it with a
badly stripped subset of Word. It generates tons of garbage code using
Microsoft style sheets only available over the web. The normal thing is to
set it to strip out unnecessary code that does away with some unused
imbedded styles. [Please don't ask me why they imbed scores of styles when
using style sheets!] This also seems to strip out my </span> close span
statement and lose all the text until they use a span statement. I do not
yet see how to deal with that, even by unchecking the 'reduce size' box.
When I try and open my 2003 Install workbook, it simple deletes all of the
sheets. I have not even looked at PowerPoint yet.
Has anyone uncovered the secret of getting this sort of thing working with
Office 2007?