Excel macro can't open word doc's that have templates

[Pinkrope11]

Hey everyone,

I've got a rather larger macro that runs from Excel and pulls data in from word documents. This macro works great for regular word documents that don't call templates. However, when the macro tries to open up a word document that is referencing a template, from what seems to be an auto call macro within the document, i get a run-time error:


Run-time error '5180':

Word cannoot open this document template.
(C:\...\Asdft Template.dot)


I can open the word document by hand on the computer without a problem I just can't get the macro to do it.

The link of code throwing the error within vba is:

Set wdDoc = wdApp.Documents.Open(Filename:=filepath)

If anyone has any suggestions I would really appreciate it!


Thanks in advance!

 

[pedie]

try this code:

Sub Openfile()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
YesNo = MsgBox("Would you like to open the folder to see" _<o></o>
& vbCr & "which files are currently there?", vbYesNo + vbQuestion, "Open file?")<o></o>
Select Case YesNo<o></o>
Case vbYes<o></o>
myval = Shell("C:\WINDOWS\explorer.EXE /e, C:\file path here\", 1)<o></o>
Case vbNo<o></o>
End Select<o></o>
End Sub<o></o>


Lets see if this works for you!

 

[Pinkrope11]

It's giving me a type mismatch error when I try to set the shell command to a variable and when i change the variable type the resulting word code wont run. The problem is that I need to be able to use the wdDoc variable to search through the word document later in the code.


Is there a way to simply prevent the AutoOpen macro from running or even being called using vba?

 

[pedie]

So there is a code in Word too that will run when it opens up???

 

[Pinkrope11]

yea and that's the problem because i don't want the code within the word doc's to run because there is an autoOpen macro that runs in the word doc that messes up the execution of the original macro that is trying to run.