+ Reply to Thread
Results 1 to 2 of 2

Save to PDF only saves last graph created on Windows but saves whole worksheet on a Mac

  1. #1
    Registered User
    Join Date
    06-04-2008
    Posts
    16

    Save to PDF only saves last graph created on Windows but saves whole worksheet on a Mac

    I will start off by saying unfortunately I can't post my code, but I have tried recreating the problem with a simple macro and I can't; everything works fine...ugh. But, I figured I'd ask to see if anyone has had this problem, or can think of what it may be and give me some solutions to try.

    I have a table on a worksheet and I also create about 10 graphs on this same worksheet below the table. I then save to a PDF using "ExportAsFixedFormat".

    When I run the code on Windows, the only thing it saves to the PDF is a single page which has the last graph I have created. It shows nothing else. I have tried activating the sheet again right before saving, deactivating the last graph I create, still no luck.

    But, if I run the same code on a Mac, it dumps the entire sheet, table, graphs and all to the PDF perfectly fine.

    Does anyone have any suggestions of what may be the problem?

    I will also say, the Windows I'm testing on is actually running on Parallels on a Mac. I will try to test tomorrow on a Windows only machine in case this the problem for some reason.

    Thanks,

    Greg
    Last edited by wizgf19; 07-12-2012 at 09:37 PM.

  2. #2
    Registered User
    Join Date
    06-04-2008
    Posts
    16

    Re: Save to PDF only saves last graph created on Windows but saves whole worksheet on a Ma

    Well, I fixed it. I realized that if I selected a cell on the page then ran the "save to pdf" function it worked...I guess this actually deselected the graph.

    So, in my code I just do the following
    Please Login or Register  to view this content.

+ 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