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

Fertiggestellt Veröffentlicht Dec 7, 2014 Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

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

Excel Microsoft

Projekt-ID: #6833855

Über das Projekt

8 Vorschläge Remote Projekt Aktiv Dec 8, 2014

Vergeben an:

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 Mehr

$50 USD in 3 Tagen
(94 Bewertungen)
6.1

8 Freelancer bieten im Durchschnitt $53 für diesen Job

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 Tagen
(235 Bewertungen)
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 Mehr

$40 USD in 0 Tagen
(80 Bewertungen)
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 Tagen
(9 Bewertungen)
3.3
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 Mehr

$50 USD in 3 Tagen
(0 Bewertungen)
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 Tagen
(0 Bewertungen)
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 Mehr

$30 USD in 2 Tagen
(0 Bewertungen)
0.0