Forum Discussion
Data Matrix Barcodes for Excel
Does any have a technique to create DataMatix Barcode in Excel?
mtarler Did you ever find a solution. I too am in need to take a cell with data in it and generate a DataMatrix barcode if you will.
In the above is an example using a macro (with help from a website) to create a QRcode. Maybe there is a similar site to generate a DataMatrix barcode if it must be specifically DataMatrix instead of QRcode. In addition to the macro based solution above (which insert the image onto the sheet), excel has since added the new command IMAGE to insert an image INTO a cell so you could use something like:
=IMAGE("https://api.qrserver.com/v1/create-qr-code/?data="& A1 &"&margin=1")
to have that website generate a QR code based on cell A1 and then insert it into that cell.
=IMAGE("https://api.qrserver.com/v1/create-qr-code/?data="& A1 &"&margin=1")
to have that website generate a QR code based on cell A1 and then insert it into that cell.
mtarler After many hours of reading across the internet, I found one example of a macro written that does all the codes, QR, Datamatrix, Code39, EAN13... and appears to be self contained. Not positive on this. I am hesitant to use it with respect for it being Malware. I am not a programmer, just a normal guy who uses excel. I can't use web based queries due to security reasons. I am looking for something self contained.
I can end you a copy of what I found, but I don't know if it's malicious or not.
Thank you for the reply by the way.
Sean
- sure. send it to me and I will do what I can to scan it and review it for anything suspicious
- sent via PM, let me know if you didn't get it. Thank you for your help by the way. Sean