to update in a closed workbook.

[Prabhu_Bob]

Hi,

I needed to update data to a closed workbook without opening it using VBA. This means i should not use workbook.open code in my VBA which is making the excel slow. Can any one help me providing code to update in a closed workbook from another open workbook or VB form.

Thanks,
Prabhu