Great Andrew like always. I have other questions describing below I have 3 signatures in outlook Sign1 Sign2 Sign3 How to pick signature dynamically based on user input? And signature contains image /gif aswell. I found some code in google but it is not adding image and image/gif is not loading its giving error. Your idea will be greatly appreciated... TIA
Thank you very much for your video Andrew I am having one doubt regarding embedded objects When i am going to insert tab and inserting the object browse the file and attached the file how to fetch embdedd file name using vba is there any possiblity Thanks in adavance
Very pedagogical video, step by step, as usual. You make me loving Excel VBA. Thanks.
Happy to hear that you're enjoying VBA, thanks for watching!
You are the perfect maaaaaaaaaaaannnnnnnnnnnnnnnnnnnnn
Thank youuuuuuuuu😇😇😇😇😇😇😇😇
😀 you're very welcome, thanks for watching!
Thank you. Very nice. Can I do it without background?
Great Andrew like always.
I have other questions describing below
I have 3 signatures in outlook
Sign1
Sign2
Sign3
How to pick signature dynamically based on user input?
And signature contains image /gif aswell.
I found some code in google but it is not adding image and image/gif is not loading its giving error.
Your idea will be greatly appreciated... TIA
Thank you very much for your video Andrew
I am having one doubt regarding embedded objects
When i am going to insert tab and inserting the object browse the file and attached the file how to fetch embdedd file name using vba is there any possiblity
Thanks in adavance
Hi! If you've linked to the file that you've inserted you can use the SourceName property like so:
Sub GetLinkedFileName()
Dim obj As OLEObject
Set obj = Sheet1.OLEObjects(1)
Debug.Print obj.SourceName
End Sub
I hope it helps!