ExcelLee
New Member
- Joined
- Mar 4, 2021
- Messages
- 7
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
- MacOS
Hi all,
First time poster but long time VBA/Excel user.
I have a bit of a conundrum where by I have a report which utilises images which every time have to be inserted and resized manually.
To avoid this I decided to insert rectangles where the images are to go. I then tried to record a macro/write a macro to do the following however I am yet to have any success what so ever.
Workflow.
Select rectangle...
Shape Format...
Shape fill...
Choose image (note I do not want to use a file path here I want to make the file explorer window come up and the user select anything from their directory)
Insert image...
Has a black border...
End macro.
Thanks in advance all.
Lee
First time poster but long time VBA/Excel user.
I have a bit of a conundrum where by I have a report which utilises images which every time have to be inserted and resized manually.
To avoid this I decided to insert rectangles where the images are to go. I then tried to record a macro/write a macro to do the following however I am yet to have any success what so ever.
Workflow.
Select rectangle...
Shape Format...
Shape fill...
Choose image (note I do not want to use a file path here I want to make the file explorer window come up and the user select anything from their directory)
Insert image...
Has a black border...
End macro.
Thanks in advance all.
Lee