krishnak
05-08-2007, 01:31 PM
Hi All,
I am working on a script which compares the cell values of two ranges in different workbooks. I could work out the code with the actual workbooks, worksheets and range names manually written in the code before running the script. Now I want to generalize this script to select the workbooks, worksheets and the ranges while running the script. I could select the workbooks by the GetOpenFileName function. Once the workbook is open, I want to scroll to the worksheet, range and then import the information (like "Sheet2" and "A4 D65") into the script just by selecting them. The program has to wait until I select the parameters and then start running again by capturing the selected information.
Please advise how I can do it.
Thanks in advance
I am working on a script which compares the cell values of two ranges in different workbooks. I could work out the code with the actual workbooks, worksheets and range names manually written in the code before running the script. Now I want to generalize this script to select the workbooks, worksheets and the ranges while running the script. I could select the workbooks by the GetOpenFileName function. Once the workbook is open, I want to scroll to the worksheet, range and then import the information (like "Sheet2" and "A4 D65") into the script just by selecting them. The program has to wait until I select the parameters and then start running again by capturing the selected information.
Please advise how I can do it.
Thanks in advance