Automate Insert & Embed Files into Excel Spreadsheet Using VBA

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 พ.ย. 2024

ความคิดเห็น • 8

  • @tobyasuzu6907
    @tobyasuzu6907 ปีที่แล้ว +3

    Thank you for this video.. it's so very helpful..
    Please I have a question, how do you embed or intert these file to a particular range, cell or position on the excel sheet. And also howmdo we add these files on userforms as well..
    Thank you

    • @rafitsolutions4533
      @rafitsolutions4533  ปีที่แล้ว +1

      You can do that by choosing a cell range to embed it in a way that you save a text to excel workbook.
      For example,
      sh.Range("C2").Value = Me.Label1.Caption.
      with reference to the second part of the question, If I may ask, do you want to display the embed object on the UserForm, if so, I will show that in my next tutorial.

    • @tobyasuzu6907
      @tobyasuzu6907 ปีที่แล้ว

      @@rafitsolutions4533 yeah.. showing the embedded file on userform or still referring it to a particular sheet in the workbook

    • @rafitsolutions4533
      @rafitsolutions4533  ปีที่แล้ว

      Thanks, I will work on it.

    • @VijayKumar-sn6hx
      @VijayKumar-sn6hx ปีที่แล้ว

      when i was try to use macros . iam able to add screenshot but unable to attached (embded) file

    • @lalaanani3343
      @lalaanani3343 11 หลายเดือนก่อน

      Did you know that? Please tell me.

  • @MaicoMejorada
    @MaicoMejorada 4 หลายเดือนก่อน

    error when you cancel the embedding of attachment

  • @BlessedGlory-n1f
    @BlessedGlory-n1f 4 หลายเดือนก่อน

    I had an error after saving and running the code