VBA export to xlsx with images without links

  • Hi !


    I would like export the file to xlsx with embedded photos directly in the file. At this point, the file is exported to xlsx but when i open this file in another pc ,photos are not displayed.




    The current code responsible for export to xlsx:

    Code
    Application.DisplayAlerts = False
    
        ActiveWorkbook.Sheets("ASORTYMENT").Copy
        ActiveWorkbook.SaveAs Filename:="C:\Autokosmet\" & "testing", FileFormat:=51, CreateBackup:=False
        ActiveWorkbook.Close
    
        Application.DisplayAlerts = True



    FULL CODE which is designed to pair the table rows with photos ( they are in local folder).

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!