In Progress

MS Excel VBA Application template

We need a MS Excel VBA application that consolidates 3 excel files into one single file.

General

MS Excel 2010

Sheet 1 will contain a input field for data location.

Fields to hold the identified import files

A load file button to activate the import

A file mask section where the user can define a mask that allows the identification of the import files

A section where unrecognized files shall be listed.

The application shall serve as a base structure and template for further development. Detail import functionalities will be done by us.

A sample master file and sample input files as well will be provided by us.

Steps file selection

1 Select the directory where the Excel files to import data from are located by pressing buton brows

2 If 'load files' is pressed

3 Check for each file whether it matches one of the file mask.

4 If a file matches add it to the corresponding input fiels (File A, B, C or D)

5 Files that doesn't match to any of the defined masks shall be listed below 'Unrecognized files'.

Error situations

No excel file found in submited directory

File for one or more file type is missing

..

.

Steps Data Import

1 Select source data

2 check if destination contains already the source data

3 If not append data to destination.

4 Update calculated column

Error situations

Source column not found

Destination column not found

..

.

File Mask

File masks is used to setup the expected field content for a specific file by defining 5-6 Fields at a known position. This is to be set by the user!

Skills: Excel

See more: defining mask excel, excel vba application, vba load, master excel 2010, excel to application, define data structure in c, define data structure, data structure define, application template excel, application of data structure in c, application of data structure, vba error, excel vba or, excel vba and, excel 2013 vba, master excel, ms-excel, ms excel, ms excel template, excel/vba, excel 2013, button to load data from, excel add development, match update data vba, vba update excel

About the Employer:
( 8 reviews ) Oberlunkhofen, Switzerland

Project ID: #4183870

Awarded to:

FreeLAS

I have expirience in such kind of tasks.

$60 USD in 1 day
(10 Reviews)
3.7

27 freelancers are bidding on average $88 for this job

koolsidz

Excel Whiz here ;) Please see PMB

$88 USD in 0 days
(84 Reviews)
5.5
nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More

$100 USD in 2 days
(39 Reviews)
5.4
binaryromel

===== Excel expert here! Please check PM. =====

$100 USD in 2 days
(34 Reviews)
4.9
djain01

Hi, Pls check the private message for details. Thanks, djain01

$100 USD in 5 days
(12 Reviews)
4.4
diegogarcia0531

Hi, I can do the job, MS Excel VBA expert, I was developed several apps, to doing different stuff I am looking forward to work with you Best Regards Diego

$100 USD in 2 days
(8 Reviews)
4.2
jal540

I have developed many such custom VBA applications for Excel.

$100 USD in 5 days
(8 Reviews)
4.1
FLtowhid

please see my PM

$80 USD in 5 days
(4 Reviews)
3.8
Tablassus

Dear Sir This project seems quiet easy to do based on my past experience with this type of problem. Please check my portfolio website at: [url removed, login to view] I've been working on t More

$80 USD in 2 days
(7 Reviews)
3.5
vikashgadia

WE ARE EXCEL MACRO EXPERT

$55 USD in 1 day
(13 Reviews)
3.5
deatc

Hi. Please consider me for this project. Thank you.

$100 USD in 3 days
(12 Reviews)
3.3
eried

Hi, can you send me more details? your excel master files or something?

$90 USD in 5 days
(6 Reviews)
3.3
adim

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

$103 USD in 2 days
(5 Reviews)
3.3
edatawiz

Thank you for posting this offer. Please check your PM for more information.

$40 USD in 1 day
(6 Reviews)
3.2
rfreelancer2008

Hi there - Anything to do with Excel. I have considerable experience with Office VBA automation tasks. I am confident enough to help with this project in a way that there is a win-win situation at the end of this. More

$200 USD in 15 days
(10 Reviews)
3.2
JoeGreen1982

Hi, I am a professional Excel / VBA designer with over 10 years of experience in delivering projects such as this. This is a straightforward task, and I am available to start immediately, so let's get this done. More

$50 USD in 0 days
(6 Reviews)
3.2
excel4engineers

Thanks for your detailed instructions. I can do it today. Please, refer to my feed backs to get my qualifications.

$35 USD in 1 day
(7 Reviews)
2.9
KellogITSolution

Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi More

$75 USD in 3 days
(3 Reviews)
2.6
isupportu

Hi I can do [url removed, login to view] check PM

$100 USD in 0 days
(4 Reviews)
2.0
mathan4stat

Hi, I can do it in a day !.. I have 8 years of experience in fulfilling this kind of requirements. Check my PM

$30 USD in 1 day
(1 Review)
1.8
exopad

Hi, Over 10 years VBA experience here. Did several similar projects, also in Excel2010. Ready to start today. Thanks, Exopad

$85 USD in 1 day
(2 Reviews)
1.7