+ Reply to Thread
Results 1 to 3 of 3

VBA Delete Picture Not Fully Work

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    VBA Delete Picture Not Fully Work

    hi all...

    i have a new code to delete picture or image in Ms Word
    but that code only can delete picture in .png format not working in .jpg format.
    i want the code can delete in .png and .jpg both..
    how to fix the code below, I am using Ms Word 2010:
    Please Login or Register  to view this content.
    any someone help me, greatly appreciated..

    .jhon m
    Last edited by Jhon Mustofa; 08-07-2020 at 11:47 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: VBA Delete Picture Not Fully Work

    Your code is deleting shapes. I doubt the original file format of a picture is the problem.

    It could be the For Each loop and the objects collection does not handle deletion very well
    Try a Do Loop
    Please Login or Register  to view this content.
    If you still have issues post example file that demonstrates the problem
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: VBA Delete Picture Not Fully Work

    hi Andy....working perfectly..
    Thank you very much!!

+ 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. How to fully delete or rename a query in excel 2016
    By skipper.c in forum Excel General
    Replies: 0
    Last Post: 05-19-2019, 10:39 PM
  2. [SOLVED] Lookup Work Only in Box 1, Not Fully Work
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2018, 08:26 PM
  3. [SOLVED] Delete picture macro wont work
    By gregsmonti in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2016, 01:27 PM
  4. Formula doesn't work fully - help to fix
    By Cazbag in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2016, 07:10 AM
  5. Delete Clusters that are Fully White
    By iThai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2014, 08:18 PM
  6. [SOLVED] Macro doesn't fully work. Need help with rows
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2014, 06:07 PM
  7. Conditional format in macro, does not fully work
    By SET_student in forum Excel General
    Replies: 4
    Last Post: 02-10-2011, 06:53 AM

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