Andy David Clarke
New Member
- Joined
- Jun 14, 2007
- Messages
- 12
I have a rather large pdf document (7,500 pages), from which I need to print selected pages.
The list of what I need to print & what the page numbers are in an excel spreadsheet, so I wanted to try and do this via macro, but I am struggling to find any code to print from a pdf.
It is easy enough to open the pdf through the line
ThisWorkbook.FollowHyperlink Address:="filename.pdf", NewWindow:=True
But I can't figure out how to then print from this.
I am happy to print to a default printer, so all I really need is code something along the lines of:
File("filename.pdf").PrintOut Copies:=1, Pages:="256" to "259" Collate:=True
Is this possible? I have seen this sort of macro for Word (using something like Wordapp), so I fear it may be the case that Excel cannot talk to Adobe in this fashion & I'll need to pursue alternative methods, but it would be useful if anyone can provide an answer!
The list of what I need to print & what the page numbers are in an excel spreadsheet, so I wanted to try and do this via macro, but I am struggling to find any code to print from a pdf.
It is easy enough to open the pdf through the line
ThisWorkbook.FollowHyperlink Address:="filename.pdf", NewWindow:=True
But I can't figure out how to then print from this.
I am happy to print to a default printer, so all I really need is code something along the lines of:
File("filename.pdf").PrintOut Copies:=1, Pages:="256" to "259" Collate:=True
Is this possible? I have seen this sort of macro for Word (using something like Wordapp), so I fear it may be the case that Excel cannot talk to Adobe in this fashion & I'll need to pursue alternative methods, but it would be useful if anyone can provide an answer!
