I'm attaching a workbook that was initially posted by another user upon which the print function didn't work properly but I thought I had gotten it to work properly during a later post. I found various sources on the net. The code will do a print screen of the embedded google map, eliminating the display settings of excel to maximize the map portion for printing purposes. The print screen function would then open up another workbook to which the image file will eventually be pasted into it. The attached example will demonstrate this better than I can explain. The problem I'm having is that it works great in Windows XP, but it appears to print the excel display bar and duplicate some imaging, etc, when used with windows7 operating system. I'm attaching a finished print screen jpeg photo which is how with this example workbook map looks upon clicking the print button in windows xp. I have xp at home, but windows 7 at work. I unfortunately forgot to bring a photo of what it looks like in windows7, but if you use that operating system and look at this example workbook, you'll see what I'm referring to when comparing to the attached photo image. Any help tweaking the vba code in module1 (it's to lengthy to post here) to make it work in both operating systems would be greatly appreciated!
Bookmarks