Related:
- Excel vba insert picture from folder
- Insert image vba - Best answers
- Vba image - Best answers
- Insert picture in Excel macro which takes the file name refrence - Forum - Excel
- Excel - Insert the Path and File Name in a Cell - How-To - Excel
- VBA code for Insert Picture - Forum - Outlook
- Excel vba insert picture from another sheet - How-To - Excel
- Excel vba insert picture into cell ✓ - Forum - Excel
3 replies
Blocked Profile
So, is the file path going to dynamic? Meaning, will it always be stored in the same place, and called the same thing?
Post your code and we can help, we cannot produce code turn key for you.
Post your code and we can help, we cannot produce code turn key for you.
Report
adikademani
Hi ac3mark, Actually i am new to VBA, i just want to know what command can be used to call a specific picture from the hard drive. I do not have any code as such. Looking forward for you guidance . thanks:)
abkademani
Hi ac3mark,
Actually i am new to VBA, i just want to know what command can be used to call a specific picture from the hard drive. I do not have any code as such. Looking forward for you guidance . thanks:)
Actually i am new to VBA, i just want to know what command can be used to call a specific picture from the hard drive. I do not have any code as such. Looking forward for you guidance . thanks:)
captainashish
- Posts
- 20
- Registration date
- Thursday May 12, 2016
- Status
- Member
- Last seen
- November 28, 2016
Hello,
To insert a selected picture in excel:
The above code will simply insert selected picture in excel within the selected cell or range in its original size.
Thanks & Regards,
Captain Ashish
To insert a selected picture in excel:
ActiveSheet.Pictures.Insert('full path of the picture from your local drive')
The above code will simply insert selected picture in excel within the selected cell or range in its original size.
Thanks & Regards,
Captain Ashish
adikademani
Hi Captainashish,
Thanks for the quick reply. I used that command as below. The file gets inserted into the selected cell but it does not get displayed. It just says "the linked image cannot be displayed. The file may have been moved,renamed or deleted." I tried the command with different pictures inn different folders, but still it shows the same message.
Looking forward for your guidance :)
Sub pics()
ActiveSheet.Pictures.Insert ("C:\Users\Public\Pictures\Sample Pictures\")
End Sub
Thanks for the quick reply. I used that command as below. The file gets inserted into the selected cell but it does not get displayed. It just says "the linked image cannot be displayed. The file may have been moved,renamed or deleted." I tried the command with different pictures inn different folders, but still it shows the same message.
Looking forward for your guidance :)
Sub pics()
ActiveSheet.Pictures.Insert ("C:\Users\Public\Pictures\Sample Pictures\")
End Sub
Blocked Profile
This is why i don't do turn key solutions. If we helped and guided you to the solution, you would learn. Just posting some cut and paste scripts, ALWAYS ends up with:
"IT doesn't work!"
Your path has no Image file attached to it:"C:\Users\Public\Pictures\Sample Pictures\"
that is a folder path. it should be: "C:\Users\Public\Pictures\Sample Pictures\imagefile.png"
"IT doesn't work!"
Your path has no Image file attached to it:"C:\Users\Public\Pictures\Sample Pictures\"
that is a folder path. it should be: "C:\Users\Public\Pictures\Sample Pictures\imagefile.png"
Subscribe To Our Newsletter!
