need functioning VBA code for creating and saving QR codes using full ASCII character set

$30-250 AUD

In Progress

Posted

over 4 years ago

$30-250 AUD

Paid on delivery

We are a small business that is trying to implement a new inventory tracking process using QR codes in conjunction with Excel. What we want: Ability to mass create QR Codes from Excel data Include 5 lines of data per code, each on a separate line within the same Excel cell which will stay on separate lines when scanned into Excel Create each code image individually in a folder Write the first line of data (product name) under each QR code so each sticker can be identified without having to scan it We have some existing VBA code which meets most of our required needs: Allows mass creation of QR codes Creates the QR code images individually in a folder Writes data under the QR Code images But it does not provide: use of the full ASCII character set write only the first line of text for the product name maintain separate lines of text in the same cell (i.e. embed alt+enter result when scanning the QR code into excel) Write the name of the product under the code

Excel

Visual Basic

VB.NET

Visual Basic for Apps

Software Architecture

Project ID: 20912127

About the project

13 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@julesgabrielg

Hi There! I tried to play around your macro and I was able to fix the multi line problem. The reason is that you cannot have a filename with multi line texts. In order for this to work, you need to add "%0A" in the google API URL. Regarding the Ascii character, it doesn't accept the " because youre not allowed to have a file name with quotations. I have made few changes and if you want to see the result, please reach out to me via chat or you can check these files to verify: [login to view URL] [login to view URL] Have a nice day and looking forward to your response. Thanks, Jules

$70 AUD in 1 day

4.9

(6 reviews)

3.5

13 freelancers are bidding on average $188 AUD for this job

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$250 AUD in 4 days

4.9

(523 reviews)

8.5

@IshaqKN

Hi there, I am really interested in your project and would like to work on and complete your project. Python is perfect solution for your task. I will create your app from scratch/start. Will be a standalone executable; and will have a GUI. Where you will input excel file and it will create bar codes from each row and will assign it the product name as filename; so that bar code can be recognize. And your project is not so complex. Meet me, who is a knowledgeable and experienced (yet friendly) Python programmer; who recently became even Full Stack Python Developer! Can you trust and leave your project to me? See my portfolio in desktop computer/view please. I shall be very thankful to you, Ishaq

$110 AUD in 4 days

5.0

(83 reviews)

5.7

@sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

$194 AUD in 3 days

4.6

(55 reviews)

5.8

@Sunil986020

I am professional VBA developer, I can complete this project sucessfully and within 3 days, please message me to discuss on your project, Thank You

$244 AUD in 3 days

5.0

(5 reviews)

3.2

@MichealSMoreno

Dear client, how have you been? I've read your project description carefully. Presenting this proposal with 100% confident. How about discuss in chat? Waiting for your reply. Best regards.

$200 AUD in 7 days

3.2

(9 reviews)

3.3

@alemarta92

Hi, My name is Alessio. I am experienced Data Analyst and Macro/Acces Developer. I have done similar jobs . I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I can start working on this project right away. Ready to start, please message me to discuss your project in more details. Thanks, Alessio

$150 AUD in 5 days

5.0

(2 reviews)

1.9

@elmorabit90

Hello, I read your offer and I can help you. With my vast experience and my knowledge of Excel and macros, I will be able to realize this project (mass create QR Codes from Excel data) that meets your requirements. I'm Expert in Microsoft Excel, I have 4+ Years’ experience, I can help you in any kind of tasks as follows: Cell function (Custom or Excel's), Charts, Apply formulas/Advance Filter, Data Validation, Conditioning Formatting,VBA/Macros, Addin, etc… Thank you for reading, I am looking forward to working with you!

$30 AUD in 1 day

5.0

(2 reviews)

1.9

@makarid

Hi Sir, I have reviewed your job description as well & I am very confident to handle this project perfectly. Ready to start now and have it done for you as soon as possible...thanks!

$149 AUD in 4 days