Em Andamento

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

Ver mais: microsoft macro, microsoft excel test, simple macro, excel 2014 macro, excel input interface, microsoft excel macro, written file excel, simple excel macro, simple design 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, macro input output, excel macro input output, excel macro output file, macro input excel, use macro, data input macro excel, excel macro file input

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

ID do Projeto: #6833855

Premiar a:

jaylancer43

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 Avaliações)
6.1

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

Teloquence

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)
7.0
avinav606lx

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)
5.9
P0L

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)
3.3
macroPOL

Hello, I suggest the simplest solution. You can check them out here: http://www.youtube.com/watch?v=yTta2XG7pBA 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)
1.1
meenuchandwani

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)
0.0
kmn1983

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)
0.0
bblinki

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)
0.0