Hi all,
I wanted to know it is possible to embed a jpg image on a excel file. The idea is, when a macro was executed use this jpg image on the sheet.
I saw how use a jpg with a macro but you need to have this file on your computer and a specific route.
What happened if i want to run this macro in other computer?
Hope you can help me
regards,
Embed the picture on the worksheet, and use code to toggle the picture visibility. See attachment for example (with apologies for the cheesy pic)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Olly , thats a good approach, but the macro that i have generates receipts of the company (1 sheet for each employee) with all the layout.
To this layout i want to add the company logo. But i have the logo on my computer, but the person that will run the macro dont have this logo.
You could embed the picture in a (hidden) sheet, then the macro can copy and paste the picture to a chosen destination:
Obviously, change the references to suit. Attachment has example.
Please Login or Register to view this content.
haha thats! right! Sometimes you can see the easy solution!
Thank you so much!
Glad you got your solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks