Link to home
Start Free TrialLog in
Avatar of AXISHK
AXISHK

asked on

Cut the Photo and paste it on Excel

I have used the following code to display a photo on Excel. However, the photo can't be displayed if the workbook is taken away from the office.

Is it possible to save the photo on the Excel, rather than displaying it through a photo path ?

Tks


For I = iStartRow To Range("A65536").End(xlUp).Row - 1
    P = Range(Cells(I + 1, sLink).Address(RowAbsolute:=False, columnAbsolute:=False))  
    Cells(I, 1).Select
    If I = Range("A65536").End(xlUp).Row Then
        Rows(I).RowHeight = iHeight
    Else
        Rows(I + 1).RowHeight = iHeight
    End If

    ActiveSheet.Range(Cells(I + 1, sPhoto), Cells(I + 1, sPhoto)).Select                  
   
    ActiveSheet.Pictures.Insert(P).Select                                                

Next
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AXISHK
AXISHK

ASKER

Tks