I am not sure excel 2007 can do this as it is on DOS, but I need to store to a excel spread sheet the first letter of each file within each folder on a server. If this is doable can excel do this or is this a VBA macro i can run from excel. I want the program to access for the server name then go out and get and store all folders in a spreadsheet then use this spreadsheet to access each file name and store on the same spreadsheet then in a seperate tab i will count each first letter and store that on the spreadsheet.
I dont need for you to write the program just point me in the right direction as to if excel can do this or if VBA can do this. I am sure VBA can but would like it better if excel can.