Right, hopefully the collective murcbrain can help me here...
What I need to do is put together a list of all files and their location within a directory structure into a text file of some sort so that I can then paste them into a spreadsheet before writing a bit of VBA to run on them.
Now usually, I'd simply go to the command prompt, think wistfully of the days of DOS, do a dir *.* with the right switches, and pipe it into a file.
The problem is, I'm now at the Dept of H, and this being the government an' all, they have disabled the command prompt in WinXP. Also the "run" dialog is diabled (yes, even with windowskey-R).
So is there another quick and easy way that I'm missing? I could do it with a bit of VBA I reckon, but not too happy with that route for other reasons related to what I'm building. Or even take the directories on a pen drive home, but not happy with that either as I may have to repeat regularly.
TIA
Gnep
What I need to do is put together a list of all files and their location within a directory structure into a text file of some sort so that I can then paste them into a spreadsheet before writing a bit of VBA to run on them.
Now usually, I'd simply go to the command prompt, think wistfully of the days of DOS, do a dir *.* with the right switches, and pipe it into a file.
The problem is, I'm now at the Dept of H, and this being the government an' all, they have disabled the command prompt in WinXP. Also the "run" dialog is diabled (yes, even with windowskey-R).
So is there another quick and easy way that I'm missing? I could do it with a bit of VBA I reckon, but not too happy with that route for other reasons related to what I'm building. Or even take the directories on a pen drive home, but not happy with that either as I may have to repeat regularly.
TIA
Gnep
Comment