Upgrade Office 2003 to 2007 .dot reference no longer working

[Dan.KSU]

Okay, I have a .dot file (let's call it the Client) which references
another .dot file (let's call it the Master). The Master has
functionality that all the Clients have in common, so the Clients will
call functions from the Master. Now this file pair has been working
without issue for several years on Office 2003. We are about to
upgrade to 2007 so I am starting testing.

Of course it fails....Now, it basically seems like it is not accessing
the Master file. Here is what I've been able to narrow it to.

If I just run the Client, I get an error telling me that it cannot
access a hidden file.
If I first ru the Master and then open the Client, I get the same
error message.
However, If I open the Master then Open VB Editor and unlock the
Master file, and then run the Client it works just fine!

So I am thinking something has changed in either the way 2007 accesses
reference files or some security setting is keeping it from opening.

I've verified that in the Client file that Reference to the Master is
valid. I've also tried playing around with some of the Trusted
Setting to see if it was hanging there.

Any help would be greatly appreciated!
Daniel

 

[Doug Robbins - Word MVP on news.microsoft.com]

What do you mean by "unlock the Master file"?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Dan.KSU]

What do you mean by "unlock the Master file"?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

The Master file is a separate .dot file that it password protected.
When referenced in the Client file, the project is "Unviewable" or
"Unavailable". In order to get Master file's code to run from the
Client file, I had to first open the Master file and then in VBE
unlock the Master file (i.e. type in the password). This would then
allow the Client file to execute the Master file's code. This is of
course not a viable solutation.

On a side note, I was able to merge the Master file code into the
Client file and it works with no problems. So I am very sure that
there is just some security setting, or missing library that is keep
the Client from accessing the Master file's code.

Thanks for the help!

 

[Doug Robbins - Word MVP on news.microsoft.com]

Where is this "Master file" located? Is it a global template that is
located in the Word Startup folder. Having password protection applied to
it should not affect its use.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

What do you mean by "unlock the Master file"?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

The Master file is a separate .dot file that it password protected.
When referenced in the Client file, the project is "Unviewable" or
"Unavailable". In order to get Master file's code to run from the
Client file, I had to first open the Master file and then in VBE
unlock the Master file (i.e. type in the password). This would then
allow the Client file to execute the Master file's code. This is of
course not a viable solutation.

On a side note, I was able to merge the Master file code into the
Client file and it works with no problems. So I am very sure that
there is just some security setting, or missing library that is keep
the Client from accessing the Master file's code.

Thanks for the help!

 

[Dan.KSU]

Where is this "Master file" located?  Is it a global template that is
located in the Word Startup folder.  Having password protection appliedto
it should not affect its use.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com








The Master file is a separate .dot file that it password protected.
When referenced in the Client file, the project is "Unviewable" or
"Unavailable".  In order to get Master file's code to run from the
Client file, I had to first open the Master file and then in VBE
unlock the Master file (i.e. type in the password).  This would then
allow the Client file to execute the Master file's code.  This is of
course not a viable solutation.

On a side note, I was able to merge the Master file code into the
Client file and it works with no problems.  So I am very sure that
there is just some security setting, or missing library that is keep
the Client from accessing the Master file's code.

Thanks for the help!- Hide quoted text -

- Show quoted text -

All good thought Doug. The Master File is stored on a different
network drive however, I moved the Master file into the same folder as
the Cleint. As for password protection, yes it was password
protected, however, I removed that with no luck.

Thanks again,
Daniel

 

[Dan.KSU]

All good thought Doug.  The Master File is stored on a different
network drive however, I moved the Master file into the same folder as
the Cleint.  As for password protection, yes it was password
protected, however, I removed that with no luck.

Thanks again,
Daniel- Hide quoted text -

- Show quoted text -

Update:
I removed the reference to the Master file and am no longer able to
add it back.
I get the Error "Can't add a reference to the specified file."

To make sure this is not an issue with the code I created the
following case:

Created Client.dotm and Referenced.dotm

Here is the code for Client.dotm
Public Sub Main()
Application.Run "Referenced.TestRef"
End Sub

Here is the code for Referenced.dotm in Module TestRef
Public Sub Main()
MsgBox("Test")
End Sub

When I try to add the reference in Client.dotm to Referenced.dotm I
get the same error.

 

[Dan.KSU]

Update:
I removed the reference to the Master file and am no longer able to
add it back.
I get the Error "Can't add a reference to the specified file."

To make sure this is not an issue with the code I created the
following case:

Created Client.dotm and Referenced.dotm

Here is the code for Client.dotm
Public Sub Main()
   Application.Run "Referenced.TestRef"
End Sub

Here is the code for Referenced.dotm in Module TestRef
Public Sub Main()
   MsgBox("Test")
End Sub

When I try to add the reference in Client.dotm to Referenced.dotm I
get the same error.- Hide quoted text -

- Show quoted text -

Okay I think I've found out what it going on here
It seems like in 2007 you can't reference an .dot or .dotm from
another .dot/.dotm only a .docm.

The downside to this is that the referenced .docm will open where
a .dot or .dotm file will not open an additional window

Let me know if you can think of a workaround to this.

Cheers,
Daniel