Hey guys,
I'm getting a 438 on the below code. I've taken it straight from the microsoft website and have no idea why its not working. anyone have any clues?
Getting the error on the red line. I can see that the folder and file is correct. Do i need a particular reference library to run this?
Any help would be greatly appreciated
Please Login or Register to view this content.
I always print it to the immediate window.
(I looked for an hour at some code I have written a while ago, but couldn't for the life of me, see that 2014 and FY14 were different.)Please Login or Register to view this content.
Is this Word, or Excel? You can't Application.Printout with Excel (Only Word)
You'll have to load the workbook first.
Last edited by Tinbendr; 04-17-2014 at 10:00 AM.
David
(*) Reputation points appreciated.
Hi Tinbendr, Thanks for your advice!
So is there another way for me to print all word documents in a folder using an excel macro?
You'll have to declare a Word Application object, then use Application.Printout.
Not tested.
Please Login or Register to view this content.
Last edited by Tinbendr; 04-17-2014 at 11:22 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks