rkc2009
01-13-2009, 06:22 AM
Hey everyone,
I just had a few questions as I am new to VBA on Excel. I need to create a macro that takes data from multiple files and stores the results in a table. The table is in a separate file from the files which the macro operates on and is updated as the macro operates on the said multiple files. I know how to run the code on one worksheet but I am not familiar as to how to run the code on multiple files in one folder and to store the data in a separate table. The table basically represents how many worksheets passed the given test and how many failed. For example, there is a parameter file that says a set of data passes if its above 5 and fails if below 5. I need to create a macro that compares this parameter file with each of the files selected and then updates the pass-fail table in another file. If anything I have said is not crystal clear, leave me a message. I look forward to hearing replies.
I just had a few questions as I am new to VBA on Excel. I need to create a macro that takes data from multiple files and stores the results in a table. The table is in a separate file from the files which the macro operates on and is updated as the macro operates on the said multiple files. I know how to run the code on one worksheet but I am not familiar as to how to run the code on multiple files in one folder and to store the data in a separate table. The table basically represents how many worksheets passed the given test and how many failed. For example, there is a parameter file that says a set of data passes if its above 5 and fails if below 5. I need to create a macro that compares this parameter file with each of the files selected and then updates the pass-fail table in another file. If anything I have said is not crystal clear, leave me a message. I look forward to hearing replies.