List folder contents in excel


I have a report folder with a lot of XLS and HTML files. I need to list al these files into Excel. Anyone any script I can use to automate this?



0 Comments   [ + ] Show comments

Answers (1)

Posted by: anonymous_9363 13 years ago
Red Belt
Hi. Very late in the day, as it were, with a response but I've only just ventured onto this part of AppDeploy: I'm more usually on 'Package Development'. Anyway, I have a generic script which walks a folder tree looking for files with a particular extension and adding the file names to a dictionary object. It could easily be adapted for your purposes. Accessing XL is easy, as it has a neat object model. I have a basic XL script which demonstrates some basic features. PM/email me and I'll send them to you or, indeed, anyone who stumbles across this post.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ