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   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


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.
Answered 07/27/2007 by: VBScab
Red Belt

Please log in to comment