List folder contents in excel
Hi,
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?
Regards
BaldEagle
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?
Regards
BaldEagle
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
anonymous_9363
17 years ago
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.
so that the conversation will remain readable.