how to update a similar sheet in a different workbook without opening that workbook

[hattisaeed]

say i have a sheet on my computer and there is a main workbook containing all the sheets of my colleagues i wish top update my sheet and the data also updates the tab of my sheet on the main file on the server without actually opening it.

[abousetta]

I don't have any experience with this, but this may put you on the right track:

http://msdn.microsoft.com/en-us/library/ff921204.aspx

abousetta