View Single Post
 
Old 05-11-2023, 10:06 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 108
MartinGM is on a distinguished road
Default

Correction - that isn't what I wanted to do - I am not finding it easy to describe, sorry about that.

This is what I am trying to do, all in VBA

1. I set the path of the folder from which I want to insert the picture. this works fine
2. I open the dialog, pointing at the folder. this works fine
3. I click on the picture I want to insert, and it is inserted. this works fine
4. This is the bit that doesn't work any more - I want to capture the filename of the picture I have just inserted. I used to use the AltText property which contained the filename, but that is no longer imported with the picture.

How can I find the filename of the picture I have clicked and inserted ?

Thanks
Reply With Quote