EXPLORE

4.8

(164 reviews)

Virendra Singh B.

@vsprybhanu

4.8

164

6.3

96%

Excel | VBA Macro | VB6 | Excel Automation

$20 USD / Hour

・

India (7:37 PM)

・

Joined on November 12, 2012

・

12 Recommendations

$20 USD / Hour

・

Hello! Welcome to my profile. I specialize in Excel, VBA, VB6, and Excel Automation, helping businesses like yours unlock the full potential of their software solutions. With more than 10 years of experience in Excel automation, VBA and Visual Basic. I've successfully delivered numerous projects, automating processes, building robust applications, and optimizing performance. What I Offer: ✅ Excel Automation ✅ VBA Macros ✅ Excel to XML ✅ Excel to Word Report with graph ✅ Get data from multiple excel files and put them into one file ✅ Text file to excel ✅ Excel to Text file ✅ Formatted reports from excel ✅ Inventory Management ✅ Mail Merge with Access, CSV, MySQL, SQL database ✅ Autofill Webform from Excel ✅ Excel to MySQL ✅ Data Entry ✅ Split Data ✅ Time difference between two dates ✅ Import data from word to excel ✅ PDF to Excel ✅ Excel to PPT ✅ Excel to Word ✅ Calendar for Excel ✅ Data cleaning ✅ Conditional formatting ✅ VB6 Development ✅ VB.NET Development ✅ Database Integration ✅ Legal Password Recovery for Excel Workbooks, PDFs, Word Documents

Verifications

On time

88%

On budget

97%

Accept rate

86%

Repeat hire rate

15%

See all Visual Basic Developers in India

Portfolio

I created Excel VBA Program to search specific Barcode in excel file and print searched record as Label (width 65mm, height 29mm) with Barcode in Brother QL570 label printer.

Label Printing in Visual Basic

Client had Dashboard where all data was calculated with Formulas and she wants to replace all the Formulas with VBA Programming. So, she needs an Excel VBA Program that can replace all formulas and give correct result. I have created VBA Program to fulfill this requirement of my client and she is very satisfied with my work.

Dashboard with Excel VBA

Mail Merge with MySQL and Excel

Mathematical Calculation

Client had requirement to apply formulas into various locations to automate the work, exchanging data between sheets, using drop down box, validation and conditional formatting. I have done all these things by Excel VBA programming.

Excel spreadsheet

Background:
I run a small retail business and I would like to better understand my sales performance and trends. I am able to export a .csv file from my point-of-sale system which contains a portion of sales data. The attached orders.csv file contains some data from January 2015 through mid-March 2015.

Rquirements:
I would like to have an Excel spreadsheet which would allow me to import these .csv data files into a single “Sales” sheet on an occasional basis (likely once per month). I would then like a “Summary” sheet which presents some key performance indicators in both data table and chart form.

NOTE: While it would be neat to do so, I do not need to track Product Code; however, you will notice in the orders.csv file that there is often more than one row per order number (see row 3 and row 4). This happens when a customer orders more than one product type. For my purpose I need to combine those records into one and simply enter the total quantity sold amongst all products

Creating Dashboard in Excel VBA

Label Printing in Visual Basic

Dashboard with Excel VBA

Mail Merge with MySQL and Excel

Mathematical Calculation

Excel spreadsheet

Creating Dashboard in Excel VBA

4.8 · 164 Reviews

164 Reviews

Cross-Platform Web & desktop PDF Scraper

The project was supposed to be a program that could scrape data off Pdfs and certain sites that have PUBLICALLY POSTED tabular text information, although sadly it caused a serious PC crash and later it was discovered through 3rd party security software and a hired Cyber Security Firm that the deliverable contained exploitative scripts and code to execute the Trojan Clip Banker for Clipboard hijacking and sending of banking and crypto wallet password data to an unknown and obfuscated email address which is a very dangerous and underhanded tactic. I cannot say for certain but it is surmised that the freelancer may have found the program collected from a general location on the web and attempted to modify it for our project and purpose but one will never know because the damage it did to my PC sent it to the scrap heap. Please Beware.

+5 more

Excel to PDF Quotation Tool

Virendra was very responsible in rectifying the issues. I will continue working with him for future works. Thanks

Delivered the project on time

Visual Basic for Apps

Excel Macro Code

It was a valuable delivery by Virendra ji that was quick and effective. He is quite professional in his approach and accommodated to make a last moment update after Milestone was cleared. Highly recommend him for any VBA related problem solving.

combo box access from sqlite

competent and reliable freelancer

Visual Basic

Microsoft Access

English to Hindi translation and Social Media Marketing

Jul, 2017 - Nov, 2018

•

1 year, 3 months

WENDS (UK)

Jul, 2017 - Nov, 2018

•

1 year, 3 months

I was working on this company as a translator. The company used to give me content in English and I used to translate it into Hindi. After the translation, I used to post the translated Hindi content in the company's Facebook and Twitter accounts.

Jul, 2017 - Nov, 2018

•

1 year, 3 months

Developing Work Management And Payroll System

Sep, 2015 - Sep, 2016

•

1 year

UNICOAST (USA)

Sep, 2015 - Sep, 2016

•

1 year

I have developed a complete system to maintain work, employee and payroll system for a company UNICOAST. The system is developed by using Excel VBA Programming. I used all windows elements like Drop Down, Text Boxes, Command Buttons etc. to make the system user friendly. It has also ability to create pdf report and send Email through Outlook.

Sep, 2015 - Sep, 2016

•

1 year

Guru Ghasidas University

2012 - 2013

•

1 year

India

2012 - 2013

•

1 year

The Fundamentals of Digital Marketing

2020

Google Digital Garage

The Fundamentals of Digital Marketing exam by Google Digital Garage.

2020

Hardware and Networking

2004

Govt.of India, Ministry of Small Scale Industries, Small Industries Development Organization, Raipur, Chhattisgarh, India

I learned during this training - Computer Architecture, Computer Fundamentals, Various Basic and Peripheral parts of Computer, Trouble Shooting, Networking Concepts, TCP IP, Bus Networking, Star Networking, P2P Networking etc.

2004

Business Professional Programmer (O Level)

2003

DOEACC Society, New Delhi India

One year Computer Course from DOEACC Society New Delhi, India. In this Course I learned Advanced PC Software - MS-Word, Excel, PowerPoint, Access, Windows Operating System and Programming Languages - Visual Basic, FoxPro etc. DOEACC Society is an autonomous body of Department of Information Technology, Ministry of Communication and Information Technology, Govt of India for accreditation of Computer Courses under the AICTE-DIT Scheme.

2003

Preferred Freelancer Program SLA

Basic Numeracy

Freelancer Orientation

VB6 Programming

VB.NET

Employer Orientation Exam

US English