Office 365 Word Macro Question

[sungen99]

The macro code below works GREAT in excel as well as in publisher but when I try to run it in Word i get a "runtime error 13 type mismatch error.

Would anyone please give me a little help here.

Thank you so much!

Please Login or Register  to view this content.

[mjr veverka]

It's because of a bad (undeclared) constant - the "pbFixedFormatTypePDF" constant doesn't come from word.


Edit:

If you want to use the same schema in different office programs, then you must explicitly declare all constants that appear in this schema, because each of them has a different value, which is used by the "ExportAsFixedFormat" command.

[nigelog]

try

Please Login or Register  to view this content.

[Arkadi]

The filetype constant is incorrect for word:

Please Login or Register  to view this content.