Word 2003 VBA vs Word 2007 VBA (VBA Word 2007)

[mdenison]

Folks,

Our Systems people have started rolling out new PC's with Windows XP and Office 2007 installed. Unfortunately there a couple of us developers with various template projects developed under Word 2003 and Windows 2000. The code in the templates work with a number of 'boilerplate' documents that have the attached template set to the working template (2003 version).

We're getting a couple of run-time errors under Windows XP and Word 2007:

1) unable to open document - invalid network drive specified' using UNC file specs. The network drive is readily accessible using Windows explorer. If you go into debug and step through the documents.open command, the document opens.

2) Another project has Access 2003 launch a Word document, with code in the attached template that runs from the AutoOpen sub. With this project we get a run-time error 'unable to run the specified macro'. Yet we can open the template and see the macro. Everything is Public, etc. and worked fine in the last couple of versions of Word.

Word 2007 is set to run in compatibility mode.

Are there issues running 2003 templates and documents in 2007?

We still have to support 2003 on Windows 2000 since the corporate-wide roll-out isn't for some months yet.

[jscher2000]

I only have Office 2007 on a personal laptop, so I have little experience with it.

On #1, it's frustrating when single-stepping solves a problem... How is this procedure triggered? Is it possible that Word or Windows usually is doing something else that is somehow interfering with access to the network drive/?

On #2, how are you launching the document? For example, shell execute versus automation.

<hr>Word 2007 is set to run in compatibility mode.<hr>

I'm not sure what that means -- where is that set?

[kmurdock]

It's not actually set anywhere -- it just happens.

When 2007 opens an older document, it automatically opens it in Compatibility Mode. When you save it, 2007 automatically saves it back to its original format. You must specifically Save As a 2007 document (or use convert on the Office Button Menu with the doc open). Because this changes the extension to docx, it preserves your old document.

To save a template so it's not in compatibility mode, save as to .dotm format if it has macros, dotx if it doesn't. Although I've had no problems running templates in compatibility mode, some features of Word 2007 are not available until you convert.

Kim <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

[jscher2000]

Thanks for the clarification. I thought it might be more far-reaching than the document format. (Wishful thinking, perhaps.)

[mdenison]

Right now, I'm kinda thinking the problems are perhaps due to third party software (Norton Antivirus comes to mind), something in the 'new' WinXP versus our old Windows 2000 settingwise or something. A number of templates are affected and it seems curious that they work just fine on our current Windows 2000 and Office 2003 platforms.

[wdwells]

One item that caught me; Office 2007 has done away with Office Assistant, so any code which used the Assistant to communicate with the user needs to be converted to MagBox.