having trouble in executing macro from other workbook

Hi All,

With the solution mentioned below, I am able to execute the macro correctly in any other workbook. However the problem that I run into is that the output is not correct. But when I execute the macro on any worksheet in the same file, the output works fine correctly. I do not know what is so special about the workbook that contains the macro which lets it handle everything correctly. I had basically taken a uniqueitem lookup function developed by one of the members of the forum and used it and that does not seem to function correctly in the new workbook. Any ideas as to what could be the problem.

The attachment description is following:
1) 5x7.xls: contains the macros which work fine for any worksheet in this workbook.
2) template_results.xls: Contains the file on which I am trying to run the macro from 5x7.xls workbook and the output csv file is not correct since the uniqueitem lookup function did not work correctly.

When I try to copy the contents of template_results.xls in 5x7.xls and run the macro from 5x7.xls file, I can get the correct output csv files in the format that I want. However when I execute the macro in template_results.xls file, the output csv file does not get created correctly.

Any help would be greatly appreciated.

Thanks,

Anshul

Hello Roy,

Thanks for the help. However I want the code that I have in 5x7.xls workbook to work for any workbook. Is it possible to modify the code somehow that it can work on any other workbook.

As for looping through the same sheet twice and screen updating turning off, I had got the code from one of the post in the forum to create a worksheet to a .csv file. I don't really understand each and every step of that code and hence just left as it is. If you can tell me how to avoid looping through the same sheet twice that would be great.

I thought the reason for having activating sheets is because I am working on multiple worksheets and for code to work correctly, I need to activate it. Please correct me if I am wrong.

Thanks for all the help.

Anshul