Retrive Data from another workbook.

[adam]

The code posted at Post=8982 retrieves data from the worksheet assigned in the code from the active workbook.

If this code is to be changed so that it retrieves data from the worksheet "OrderData" in the workbook at location D:\Customer\Bills.xlsx

How may I do so?

Should it be same as at Post=19565

Any suggestion on this would be kindly appreciated.

[HansV]

Yes, you will have to open the Bills.xlsx workbook in order to retrieve data from it.

But be careful: the Worksheet_Change event will occur each time the user changes a cell, so opening and closing the workbook each time might have a noticeable negative effect on performance.
It might be better to keep the other workbook open.

[adam]

Thanks for the reply Hans. I'll try to figure this out.