Disable UNC reference in VBA project

[tomxyz]

I have developed some MSWord/Excel 2000/XP templates, that all reference a central template. The central template is where all the vba code resides.

The problem I have that the referencing templates store the reference to the central template as a UNC path, for example \\dev\source\word\source.dot

It would make separation of dev and production a lot easier if the reference was stored as a drive letter, for example n:\word\source.dot,
i.e. for developers, n: drive points to \\dev\source, and for users, n: drive poinst to \\prod\source

I found an article that describes how to disable UNC for word, but unfortunately it doesn't apply to the VBA editor.
(

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q171406)

Any help greatly appreciated.

 

[uberpudge]

Hello Tomxyz,

Perhaps some sample code would be in order, to see how your code is referencing the UNC?

This would help greatly.

Hope this helps,
Pete

 

[tomxyz]

Hi uberpudge,
There is no code doing the referencing.

The templates are setup to reference a central template using the standard Visual Basic Editor - Tools / References / Browse menu.

You can browse to a networked template\admin such as N:\dev\theCode.dot (where N: is a mapped network share), but when you return to the references screen, you'll see that the path to theCode.dot has been magically transformed to \\server\share\dev\theCode.dot.

Cheers, Tom.