Macro for insert picture
Closed
samirbandri
Posts
2
Registration date
Thursday October 29, 2015
Status
Member
Last seen
October 30, 2015
-
Oct 29, 2015 at 04:44 PM
Blocked Profile - Oct 30, 2015 at 04:57 PM
Blocked Profile - Oct 30, 2015 at 04:57 PM
Related:
- Macro for insert picture
- How to insert picture in word without moving text - Guide
- Convert picture to shape powerpoint - Guide
- Insert check mark in word - Guide
- Microsoft picture manager download - Download - Image viewing and management
- Insert draft watermark in word on all pages - Guide
2 responses
OK do you see the relative path to the picture? Have you tried this yet since present is the path?
present = Dir("C:\Users\Administrator\Desktop\LC\" & picname & ".jpg")
ActiveSheet.Pictures.Insert(present)
present = Dir("C:\Users\Administrator\Desktop\LC\" & picname & ".jpg")
ActiveSheet.Pictures.Insert(present)
samirbandri
Posts
2
Registration date
Thursday October 29, 2015
Status
Member
Last seen
October 30, 2015
Oct 30, 2015 at 03:54 AM
Oct 30, 2015 at 03:54 AM
Thanks
i can change file path, but main problem is i have only item_code in other column (like 110002347) but file name has more character (like 110002347, 2pc, 12x50x10cm).
Thanks
i can change file path, but main problem is i have only item_code in other column (like 110002347) but file name has more character (like 110002347, 2pc, 12x50x10cm).
Thanks