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 a picture into a picture in word - Guide
- Picture manager download - Download - Image viewing and management
- Insert key - Guide
- Insert check mark in word - Guide
- 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
