Peter
Why re-invent the wheel?
One method to pull directly to Excel is to use Tushar Mehta's Excel Add-in.
This allows filtering and sorting once you have the data in Excel.
http://www.tushar-mehta.com/ scroll down to Add-insDirectory Listing.
Download the ZIP file and un-zip to your Office\Library folder.
Load through ToolsAdd-ins to get a Menu Item added to your Toolbar for
one-click service.
Gord Dibben Excel MVP
On Tue, 14 Jun 2005 17:54:51 -0500, PeterO
wrote:
*List Files in excel* Hi Guys,
I need some help, I am new to VB and I am looking to create an excel
sheet that I can point at a folder and and create a file listing from
it. For example:
File Name, Creation date, file type, file size.
I would like to have just one button that asks me to point a the folder
and it does the rest.
any advice would be really helpful
Peter