how can i automatically update the excel sheet if new files are added in a
folder.(that folder contains various files which are entered there in the
folder)

Amit,
In rough order of complexeasy :

The full way is receive notification from the system:
http://vbnet.mvps.org/code/shell/shchangenotify.htm

A more simple (but still API) route is:
http://vbnet.mvps.org/code/fileapi/watchedfolder.htm

Otherwise, you can use a timer/OnTime to get the content of the folder using
Dir() and compare the current contents with an array previous filename.
(Basically implementing your own version of the above method.)

NickHK

"amit" wrote in message
...
how can i automatically update the excel sheet if new files are added in a
folder.(that folder contains various files which are entered there in the
folder)