Data input from QR code is not what excel is expecting

[aidanw02]

We are having issue getting excel to accept the data from the scanned QR code. When we scan the code it shows the following error:

Run-time error '9':
Subscript out of range.

When I click on debug it points to line that reads "value = par(1)" in the QRCodeInput macro. From what I can tell, it's expecting an equal sign in the data from the scanned QR code. If I manually put data into the input field of excel and add an equal sign, then it does fill out the tables with data that isn't properly segmented.

Any help you might be able to give would be appreciated.
Thanks