Passing variable to Word BYRef argument Type Mismatch

[pjwhitfield]

Im trying to pass data from an Excel sheet to a Word doc, I've created the most basic of test code but no matter what I try I always get the same "ByRef Argument Type Mismatch" error.
In Excel

Please Login or Register  to view this content.

While the Word doc has

Please Login or Register  to view this content.

I've tried adding ByRef, ByVal etc but always the same error

Anyone tell me what Im doing ridiculously wrong?

[EarlyBird2]

Hi pjwhitfield,
Are you running your subs on module level? If not, try so and tra using a function in your .docm file, and try to declare your Excel sub public instead.
//EarlyBird2

[xlnitwit]

Your code works properly for me. Are you sure you don't have another test routine that is being called?

[pjwhitfield]

Thanks for the posts folks,

As per EarlyBirds thoughts I've tried moving the code to a module...same issue, I've then tried changing to a Function (both in Module and Document)...same issue.

As xlnitwit was saying the code worked I then decided to put the Word code into a new blank document and yes it worked fine.

So the issue would appear to be in the Word doc that Im amending, unfortunately Im unable to upload it as its a business sensitive document, has anyone got any ideas what else could cause this?

There is no other VBA in the document however there is a Reference shown within VBA to another document however I cant access any code via my document and when I open the referenced doc theres no VBA there either?

[xlnitwit]

If you change the name of the routine and arguments to something else, does it make any difference?

[pjwhitfield]

Nope, I changed the routine (in the Word doc) to "sausages" and the argument to "PorkData"

safe to say that, unless the document Im working on is from Richmonds Sausages Ltd then chances are those names dont exist elsewhere.

Same error.

[xlnitwit]

Do you actually need to pass it ByRef? Does the error go away if you use

Please Login or Register  to view this content.

[pjwhitfield]

No, the only reason ive tried adding ByRef was because I was getting the error, ive tried ByRef, ByVal and just the straight variable both with and without the "As String".

Everything gives the same error message.

I think this may require the word document to be recreated and try from there. Its just bugging me when I cant see a reason for the problem.

[xlnitwit]

What happens if you comment out the Run line completely?

[pjwhitfield]

The Word doc opens as expected, no errors raised.

[xlnitwit]

I'd have to see the document then (you could remove all data). There is no reason that an argument passed ByVal should ever cause a ByRef mismatch.

[pjwhitfield]

I think the issue is the fact this document was originally produced from a central template which is the document thats mentioned in Document References. I cant see any way to remove that reference. I've tried through Properties>Remove Properties but that states it cant be done as the document is "open in COM Surrogate" (my doc isnt open so it must be referring to the template doc).

I have now recreated the document from scratch and its working fine.

Would be nice to understand exactly what the issue was because it definitely couldn't be conflicting Sub or Data names.

xlnitwit, the data in the doc is very secure so technically I'd have to remove everything from it leaving a blank doc (well i could probably leave the header in).