Hi,
I have come code that generates a pdf, however, it opens at quite a small zoom % i.e 73.2 and I need it to be around 125% so that people can see the detail on screen before they print.
I have looked everywhere but cannot find any code to do this. Is it possible? I have read somewhere that VBA cannot control the zoom in a pdf but I'm shocked if that's the case.
Thanks
MissDB
May Be
Please Login or Register to view this content.
Regards
Parth
I appreciate your feedback. Hit * if u Like.
Rules - http://www.excelforum.com/forum-rule...rum-rules.html
Hi,
No that doesn't work, I get an "Object does not support this property" error and the resulting pdf is as before i.e. no bigger
Thanks
Miss DB
Does the PDF Open in Abode?
Yes it does
If you are using Adobe Reader the options are indeed quite limited, Adobe uses it's custom window, handles etc. to control the application.
To accomodate this, the offer an API to interact with, however the (free) Reader function isn't opening up it's API.
Nevertheless, all remaining Window API functions still remain and can be used. So it takes some time and effort, but it is possible.
If you want to proceed I can recommend this URL http://www.myengineeringworld.net/20...-with-vba.html
This approach (and some other things with PDF on the site) can make it happen.
It might need a tweak somewhere, since Adobe tends to change their internal controls, handles and menustructure sometimes when switching version.
Regards,
Rick
Last edited by rkey; 09-04-2015 at 07:44 AM. Reason: changed the link to an URL
Thanks Rick, interesting information and really detailed, thank you. I will review, but I think on the face of it I need to find an alternative solution/workaround as I don't have enough time to investigate at this point.
Best wishes
D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks