Thread: Bulk processing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PO PO is offline
external usenet poster
 
Posts: 66
Default Bulk processing

Hi!

Excel 2000.

I'm trying to create a .xlt which contains code that opens and processes all
..xls-files in a certain direktory on the users harddrive.
I need to write VBA looking something like this:


Dim xls as Excel.Workbook

For each xls in "Directory on Harddrive"
Open xls-file
Check for a certain value in xls
Close xls-file
Next


Any ideas on how to write this code?

TIA
PO