ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   printout method on embedded word doc fails - PART 2 (https://www.excelbanter.com/excel-programming/385760-printout-method-embedded-word-doc-fails-part-2-a.html)

lieven

printout method on embedded word doc fails - PART 2
 
I have a word doc embedded in an excel sheet. when i try to print the word
doc from vba i always get a runtime error 4506 : method not available on the
".printout statement".
I have even tried putting a print macro in the embedded word doc :
sub PrintMe()
activedocument.printout
end sub
very simple indeed, but when accessing(not running the macro) this embedded
doc from vba, i get the runtime error message 4506 : method not available

i have tried everything from early binding to late binding but to no avail.
it seems like the Word printout method is not accessible from excel

has anyone experienced this problem ? or have a solution ?


thanks


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com