Results 1 to 7 of 7

Thread: VBA : Insert Pictures With Multiple Select Picture & Consecutive Placing

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Hi

    You should not think of it as …. combine Alan code into muhammad code … that wont work. That’s wrong.
    Correct is: combine muhammad code into Alan code


    __Do While
    __Dim FullPathAndFileName As String
    __ Let FullPathAndFileName = Path & "" & FileName



    ___ muhammad code here


    __Loop



    That is a looping code section. It is done 2 times if you have two files, 3 times if you have three file, 4 times if you have 4 files, 5 times if you have 5 files, 6 times ……….etc.

    Each time it is done, my FullPathAndFileName = your vPicture

    In my example it would have looped 2 times because I had two files in my folder, Picture Example Folder, ( https://i.postimg.cc/7b8WngcR/Pictur...My-Desktop.jpg )


    I do not think it is possible to explain this any easier. That is very very simple and most very basic looping programming understanding.





    But I cannot tell you exactly what coding to put here, because I do not know how to do coding that involves inserting pictures. I have no experience inserting pictures.
    Somebody else will need to help you if you are unable yourself to proceed further.




    ( For somebody else to help you, it might be easier for them to help you if you explain in more full detail of your requirements and include some sample files )

    Alan





    P.S.
    Quote Originally Posted by muhammad susanto View Post
    .. actually i'm newbie about macro.
    You have been doing macro for at least 9 years already . I have been doing macros for 6 years only. So I am super newbie
    Last edited by DocAElstein; 01-27-2022 at 01:33 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    KILL A MODERATOR!!

Similar Threads

  1. Replies: 3
    Last Post: 07-09-2020, 02:17 AM
  2. Replies: 0
    Last Post: 07-08-2020, 07:43 PM
  3. Macro To Browse&Select File and import Specific Data
    By madeinnorway in forum Excel Help
    Replies: 0
    Last Post: 09-20-2019, 01:24 AM
  4. Insert Different Picture into Multiple Sheets
    By muhammad susanto in forum Excel Help
    Replies: 4
    Last Post: 08-28-2018, 12:01 PM
  5. Insert Picture in a Cell UDF
    By Admin in forum Download Center
    Replies: 10
    Last Post: 12-07-2012, 04:49 PM

Posting Permissions

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