VBA formula not working, trying to insert an image

[Joe84]

Hello

So I recently added some QR codes to an excel sheet I was using to generate labels.
And now I wanted to generate these labels automatically, however im stuck on this section of code.

I have been trying for a few days to make it work.
My Excel is in spanish, but I have translated the formula to english.

The code in B2 is working fine if it is introduced manually, but VBA doesn't seem to recognise it.

Worksheets(SheetName).Cells(2, 2).Formula = "=IMAGE('https://api.qrserver.com/v1/create-qr-code/?size=150x150&data='&TEXTJOIN(,,A2,A1))"

Any help would be much appreciated.

Regards

 

[RudRud]

"=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="" &""TEXTJOIN(,,A2,A1) "")"

how about this?

 

[RudRud]

or this might be more accurate instead?

Cells(2, "b").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&A2&A1)"

 

[Joe84]

View attachment 94509

"=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="" &""TEXTJOIN(,,A2,A1) "")"

how about this?

Thank you so much, this worked perfectly

 

[Joe84]

or this might be more accurate instead?

Cells(2, "b").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&A2&A1)"

This didnt work, but I found a solution, thanks

 

[RudRud]

Thank you so much, this worked perfectly

i think you should double check again regarding the images, make sure the images all are being inputted correctly (desire barcode address with correct output barcode).

my site here sometime the output of barcode didn't update on time

 

[Joe84]

i think you should double check again regarding the images, make sure the images all are being inputted correctly (desire barcode address with correct output barcode).

my site here sometime the output of barcode didn't update on time

Yes actually you are right, I saw a QR code and thought, ¡this worked! and immediatly moved on to the next issue
The QR code literally reads "Textjoin(,,A1,A2)" and not "CB1200"

 

[RudRud]

Cells(4, "b").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&TEXTJOIN(,,A2,A1))"
Cells(2, "b").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&A2&A1)"

Cells(4, "e").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&TEXTJOIN(,,D2,D1))"
Cells(2, "e").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&D2&D1)"

2options, should be okay? But again, make sure the images all are being inputted correctly (desire barcode address with correct output barcode) and Capital letters as well

 

[Joe84]

View attachment 94520


Cells(4, "b").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&TEXTJOIN(,,A2,A1))"
Cells(2, "b").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&A2&A1)"

Cells(4, "e").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&TEXTJOIN(,,D2,D1))"
Cells(2, "e").Formula = "=IMAGE(""https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=""&D2&D1)"

2options, should be okay? But again, make sure the images all are being inputted correctly (desire barcode address with correct output barcode) and Capital letters as well

I tried both options and yes they work, and yes the codes are ok.

Thank you very much

 

[RudRud]

I tried both options and yes they work, and yes the codes are ok.

Thank you very much

Glad to assist, If you have any further questions, please don't hesitate to ask/share with us