+ Reply to Thread
Results 1 to 4 of 4

Convert Excel to JPG Macro does not work with newest Office 365

  1. #1
    Registered User
    Join Date
    10-19-2020
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    83

    Convert Excel to JPG Macro does not work with newest Office 365

    Hello everyone

    I have the following macro:

    Please Login or Register  to view this content.
    This macro saves an Excel file (from the folder catalog) as JPG file (in folder Picture) and this code works in Excel 2013 but not with the newest Excel version.
    With the newest version the JPG is just an empty (white) file.

    Is there some change I need to do to make it running with the current Office version?
    I have attached a test file.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by esukei; 04-27-2023 at 08:12 PM.

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,361

    Re: Convert Excel to JPG Macro does not work with newest Office 365

    Seems to work fine on my version of Excel - latest 365 Version 2304

    Maybe as you are doing this as a loop it is not being given enough time to paste the image to the chart, you could try replacing this line:
    Please Login or Register  to view this content.
    With the below lines:
    Please Login or Register  to view this content.
    To make sure the paste is completed before the code moves on
    If things don't change they stay the same

  3. #3
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Convert Excel to JPG Macro does not work with newest Office 365

    Does this work for you?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-19-2020
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    83

    Re: Convert Excel to JPG Macro does not work with newest Office 365

    Thank you, that worked!

    @CheeseSandwich
    Thank you for your help too, but unfortunately that still gave me blank images.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert Open Office Macro to an Excel Macro?
    By kal-el.Kanata in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2018, 01:06 PM
  2. Macro Help to convert an excel operation to a VBA to simplify the work
    By sudhina in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-14-2016, 10:19 PM
  3. Macro for MS Office 2010 doesn't work for 2013
    By levitikus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2015, 06:29 AM
  4. Open PDf specific page, work with office 2007 but not on office 2013
    By haktak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 01:58 AM
  5. Excel convert to Open Office CSV
    By pelikano in forum Excel General
    Replies: 9
    Last Post: 07-06-2010, 09:19 AM
  6. make old macro function to work in office 2007
    By moh7652004 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2010, 12:37 PM
  7. Replies: 5
    Last Post: 06-24-2005, 03:05 PM

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