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
0 Comments   [ + ] Show Comments

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.

Answers

0
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
Answer this question or Comment on this question for clarity