Write some Software

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

INTRODUCTION

1.0 We wish to engage a Visual Basic programmer to create two new FORMs in the attached excel file (PAT Excel Template – [login to view URL]).

1.1 The excel file contains an existing FORM B (Receipt / Payment) which allows the book keeper to enter transactions. Once, the required data has been keyed into FORM B, the transactions will be saved. A unique Entry No. will be created for the transaction. Please kindly refer to the relevant programming codes already in PAT Excel Template – Unprotected.xls. However, FORM B is NOT an efficient way to keying data. Because, only one person can key in data (using FORM B) at any one time.

1.2 Hence we require a new FORM (hereafter known as “FORM Y”) to allow it to read an excel file (Data Entry [login to view URL]) where the data will be entered. This means that multiple people can work separately to ensure that data is entered efficiently using FORM Y. FORM Y will then upload the data into PAT Excel Template – Unprotected.xls.

2.0 Another issue that we wish to address is that Data Entry [login to view URL] should ideally have the same character format and length limitations. Meaning to say that when keying data into Data Entry [login to view URL] and using FORM Y for upload, there should be any different from using FORM B.

REQUIREMENTS:

3.0 Create FORM Y with the following requirements:

a) FORM Y button should be located at the bottom of the Input Menu, below all the other existing form buttons,

b) Form Button should read “FORM Y UPLOADING OF EXCEL DATA”, include our company’s logo ([login to view URL]) and should be 3x bigger than all existing buttons,

c) FORM Y should be able to read the excel sheet (Data Entry [login to view URL]) and input data like Form B,

Note: The results of using FORM Y to upload data should be similar to using Form B to input each transaction.

d) When the data is being uploaded, there should be a status bar to show progress,

e) After the data has been uploaded using Form Y, there should be a confirmation screen with the messages (“The data from excel sheet has been imported successfully”) to inform you that the data has been successfully uploaded.

4.0 Let us know the following information obtained from the programming codes and forms in PAT Excel Template – [login to view URL]:

a) What data format should each column in Data Entry [login to view URL] be,

b) How many characters should each column in Data Entry Template. xls be,

5.0 Are there any coding to prevent data amendments when using the BACKUP / RESTORE FORM in PAT Excel Template – Unprotected.xls. If there is, please kindly highlight where is this programming code located.

Visual Basic

Project ID: #10429616

About the project

11 proposals Remote project Active 7 years ago

Awarded to:

solutionsocean

Hi, I am experienced visual basic programmer since 15 years , I can solve your problem real fast, just test me!

$100 USD in 15 days
(5 Reviews)
3.1

11 freelancers are bidding on average $264 for this job

esalem

Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaz More

$778 USD in 15 days
(14 Reviews)
6.8
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD in 5 days
(91 Reviews)
6.2
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$250 USD in 5 days
(66 Reviews)
5.8
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc More

$250 USD in 5 days
(23 Reviews)
5.5
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More

$250 USD in 7 days
(17 Reviews)
3.8
surekash7096

I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.

$155 USD in 3 days
(12 Reviews)
3.7
dmitriy8992

A proposal has not yet been provided

$166 USD in 2 days
(1 Review)
1.0
manurajpatel

Hi, I have around 8 years of experience in developing softwares in Visual Basic in my total 13+ years of experience. I am expert in writing complex SQL queries to get the desired resultset. The requirements are More

$250 USD in 5 days
(0 Reviews)
0.0