automatically updation of the excelsheet if i add new files in a .
 

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)

automatically updation of the excelsheet if i add new files in a .
 

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)