Macro to Pull Filename

I am working on a macro where the filename of a .jpg will be placed on the worksheet.  Anyone know how to pull the filename and place it?

Parents
No Data
Reply
  • Hi Harry,

    Don't know if you remember me.  You were helping me with a batch file for selecting pictures from a folder to use while executing a macro.  I have been working with a programmer I know local to me.  He was able to complete that task.  He does not know how to do the second part.

    The second part is to take the text of each .jpg file(file name) and place it under the location of the .jpg.  He can't get the file name to write to the sheet we are working with.

    I have attached the macro I am using.

    Thank you.

    -Don-

Children