Copy and export picture VBA - pixels issue
Hi,
I'm actually using chart.export command to get some .gif files.
The problem is the resolution, this is my case:
Chart width = 480 points
Screen Dpi = 96
Chart width should in pixels = 640 (480 x 96/72)
The problem is that the output file is 643 width. If I test the same file in another PC, the output file is 643 width.
Does any one know how to solve this??
Many thanks!
Hi sivanvega
Only guessing but perhaps it relates to screen resolution of the machine you're running on. There's many examples of code to find screen resolution on the Net. Having determined screen resolution, perhaps changing the Zoom level (using Case Select) may help.
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks