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
8 freelancers estão ofertando em média $53 para este trabalho
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
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.