Saving QR Image as JPG

Bib195

New Member
Joined
Dec 14, 2024
Messages
21
Office Version
  1. 365
Platform
  1. Windows
Hello Everyone,
I'm Using Excel Function IMAGE( ) to create a QR Code through an Online API link. Now I'm trying to save this created image as JPG with all the ways I know & Failed. using this IMAGE function is not placing the created code as { Insert Picture in Cell } mode, so all Chart & Shape commands are not working - at least for me with my little experience in VBA. As you will notice with the attached Screenshot, the Formula-Bar shows the IMAGE( ) I'm using!
Is there a solution to this issue as I'm stuck with it for the past 5 days...
 

Attachments

  • Untitled.png
    Untitled.png
    53.9 KB · Views: 20
Well isn't that interesting. I ran your code after updating the API and now the picture type is msoLinkedPicture (Type 11). Hmmm? Dave
Hi There,
I solved my problem using Dave's code BUT after reinserting All the picture (QR Codes) with different name for each Image (Picture), then I posted the name into a cell next to the Image Cell . Without this step, Dave's code will export all Files with the 1st shape only.
Example:
- If you have 10 Images / Pictures inserted into your sheet
- All the 10 Images / Pictures are inserted with the same name, Then
- Dave's Code will export 10 files JPG or PNG file BUT all the 10 files will have the same Image / Picture which is the 1ST Image in the Sheet.
- Accordingly, you need to Name the Images / Pictures different names while inserting it to the Sheet.
- Then Insert the name of the FILE that you want the Image / Picture to be saved as to the chosen folder into the CELL next to the Image Cell.
hope this was clear enough.
 
Upvote 0

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Thanks again Dave,
Actually I posted this Thread when I didn't have any replies to my comment into the Other Thread for 2 days.
Anyway, as I mentioned on the other Thread, the Code worked as a dream and everything is working fine thanks to your contribution.
Accept my good sincere wishes for the festive days, all the Best.
Ehab...
 
Upvote 0
 
Upvote 0

Forum statistics

Threads
1,226,536
Messages
6,191,628
Members
453,668
Latest member
Stephen_Santos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top