$$Excel-Macros$$ Copy document name & paste in excel urgent!!

2009-07-03 Thread kunal
Hi, I found something but it gave an error while running in excel 2007 but is working perfectly in xl2003 version Error came at: With Application.FileSearch the error mgs was 'Runtime error:445, Object doesn't support this action Can any one modify so that it would work on 2007 version of excel

$$Excel-Macros$$ Copy document name & paste in excel urgent!!

2009-07-01 Thread kunal
Hi, I am stuck with a problem now which is hunting me since days now. I had to sort all the document and folder structure that was there in our repository which was a mesh pending for ages. Now i am now trying to have all the list in an excel file as a content so as to find the document easily. It