View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default find all the excel files in a folder.

A couple of things -

The file type will need to be changed to CSV.
(I am not sure how to do this)

The code itself can go anywhere you want.

You can either build a special workbook to hold it. In which case
you will need to open that workbook to use it.
Or you could put it in your Personal.xls (this opens automatically
everytime you open Excel.

--
steveB

Remove "AYN" from email to respond
"jackm1" wrote in
message ...

the files are all in .csv format.


--
jackm1
------------------------------------------------------------------------
jackm1's Profile:
http://www.excelforum.com/member.php...o&userid=25399
View this thread: http://www.excelforum.com/showthread...hreadid=388721