Design a Simple User Intreface to run a pre-written macro

I have a macro written in excel that does some data analysis for me.

Problem: I receive a new input file everyday and I have to copy all the data on the excel file that contains the macro. This is very redundant and I don't want to do this everyday.

Solution: You will be developing this solution. A very simple user interface must be developed. The interface must ask the user for

a) The source of input file. (We always keep our input file in C:Jexcel)

b) Source of output file. (We always keep our output file in c:jexcel)

c) There should be a "run" button. The run button will execute the macro on the input file and revise the output file

The following files are attached:

a) Input file_mod3 : This file has the macro

b) [url removed, login to view]: Once the input file is done running, output can be seen on this file

c) Input file_test: This file does not have the macro. You must use it for test

Habilidades: Excel, Microsoft

Veja mais: design a button, microsoft macro, microsoft excel test, simple macro, microsoft data analysis, excel 2014 macro, excel input interface, microsoft excel macro, simple data analysis, written file excel, simple excel macro, excel macro data input output, simple design excel, data analysis excel file, test button design, data analysis microsoft excel, excel macro output, output macro file, output file excel macro, macro output excel, macro input, interface excel file, input output macro, excel pre, output excel macro

Acerca do Empregador:
( 3 comentários ) Ottawa, India

ID do Projeto: #6833855

Concedido a:


Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in Excel Macros/Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects a Mais

$50 USD em 3 dias
(94 Comentários)

8 freelancers estão ofertando em média $53 para esse trabalho


Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. Lets start.

$50 USD in 0 dias
(235 Comentários)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I have recently created the macro with the same functions. Next steps: Lets discuss/validate the complete requireme Mais

$40 USD in 0 dias
(80 Comentários)

Hello, I'm an excel expert and I'm interested in your project. Please contact me to discuss the issue. Thanks.

$40 USD in 3 dias
(9 Comentários)

Hello, I suggest the simplest solution. You can check them out here: [url removed, login to view] If you have any questions I will be happy to answer. Thank you very much Jan Krzyzak

$50 USD in 3 dias
(2 Comentários)

Dear sir, i hav done this type of work earlier bcoz we are team consisting of CA,CS,CWA for finalizing any report we make all these rough document in excel thats why we are quite familiar with excel,and we ll do our be Mais

$50 USD in 3 dias
(0 Comentários)

I would like to work this kind of task to generate files by using dos script. It will run adhoc process whenever you click the script .exe file it will generate file wrt output folder for current date.

$111 USD in 3 dias
(0 Comentários)

Hi, I can make you a simple interface with three buttons. The first button will open explorer, where you can select the input file. Second button would open the Explorer so that you select a folder where the output fi Mais

$30 USD in 2 dias
(0 Comentários)