+ Reply to Thread
Results 1 to 6 of 6

Need help with vba coding which works in windows xp but not as well with windows 7

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    957

    Need help with vba coding which works in windows xp but not as well with windows 7

    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!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    957

    Re: Need help with vba coding which works in windows xp but not as well with windows

    I'm attaching a jpeg image of what the print functionality creates off of Windows 7. I'm not really sure if it is the operating system that is causing this or the upgraded version of Excel. I use Office 2007 but the windows 7 systems have office 2010 version. So it could be either issue. I just know it works great on windows xp with excel 2007 and would like it to work on excel 2010 with windows 7 operating system. Any ideas anyone?
    Attached Images Attached Images

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need help with vba coding which works in windows xp but not as well with windows

    Are you using Win 7 32 bit?

  4. #4
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    957

    Re: Need help with vba coding which works in windows xp but not as well with windows

    Hello nilem, I believe it is 64 bit.

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need help with vba coding which works in windows xp but not as well with windows

    API functions for Win 32-bit systems used in your code. And there are differences in these functions are called for Win 32 and Win 64.
    Unfortunately I can not help you in more detail. Here is just a sample:
    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    957

    Re: Need help with vba coding which works in windows xp but not as well with windows

    Thanks nilem! I'll give that a try. I was also considering taking out the
    Please Login or Register  to view this content.
    and see if that helps too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1