Design a Simple User Intreface to run a pre-written macro
$30-250 USD
Completed
Posted over 9 years ago
$30-250 USD
Paid on delivery
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) [login to view URL]: 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
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 and very high completion rate. I will not disappoint you, please give me an opportunity to work with you. I will provide you with a working version of file before you award me the project. No milestones required, pay me only when your job is 100% done. Thanks, Jay
$50 USD in 3 days
5.0 (94 reviews)
6.1
6.1
8 freelancers are bidding on average $53 USD for this job
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 requirement and I can start to get this done with required quality output.
I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality.
Lets discuss more online on chat.
Thanks,
Abhinav
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 best if you trust on us,
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.
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 file will be saved. And third button is run button.
If you change limit of your Budget, I can finish your task for 25$.
Feel free to send me a message.