print external documents

Hi all,
Thanks to Greg M for the great solution provided to me! I can print docx files as I want to!
http://www.excelforum.com/excel-prog...documents.html
When I said that's everything is ok, my boss asked me it to add more documents to be printed.
If possible to print additionally ".pdf" file(s) and any other pdf or docx if they are in the same row?

The scenario is: (test file attached)
Hi all,

I need your help guys!
In sheet1 I have stations in cells B:F
In sheet1 I have button for printing specific sheets.
In sheet Airport column A I have stations also, In column B, C or D the path for additional documents I want to be printed.

What I need is:
LHR (sheet Airport column A) is matching with LHR (Sheet1 F2) somehow to print the document from column B, C or D when I hit the button1 sheet1
FRA (sheet Airport column A) is matching with FRA (Sheet1 D3 somehow to print the document from column B, C or D when I hit the button2 sheet1
MUC (sheet Airport column A) is matching with MUC (Sheet1 B4) somehow to print the document from column B, C or d ...

I really appreciate your help!

Hi Greg!
Thank you very much for your solution! It might work but now I have an issue and I hope to solve it!
I save/print pdf a lot of files (even if I do it this time I receive this error

Please Login or Register  to view this content.

"can't find project or library"- I checked references and is ticked Missing Microsoft Word 15 Object Library
I replaced "wdExportFormatPDF" with "Type:=xlTypePDF" and the next error is "wdExportOptimizeForPrint"-can't find project...,
I deleted it (lol!) and the next error is "wdExportAllDocument" can't find project..
Have you any idea?
Thanks a lot!

These are Word enumerated constants. They are unknown to excel (they are not part of excel object model) as you use late binding. One option would be to use early binding (and also change the way you create the Word Application object), the other - to use number value (e.g. 17 instead of wdExportFormatPDF), instead of enumerated constants.

I opened the file and actually you are already have reference to word object model, but not really using early binding. I change few things accordingly (marked in red)

Please Login or Register  to view this content.

Hi buran,
thank you!
the code is running 2-3 min and then pops up this error "Microsoft office Excel is waiting for another application to complete an OLE action"
and even I click ok the code runs continuously... what should I do?

I didn't have time to go in detail of all the code. It's a spaghetti code, but obviously it must wait for Word to complete some operation. I just fixed the reference to Word enumeration and early/late binding mix in the code. Greg may be of more help here.

it's ok! thank you!