Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
What I’m after is a macro that will scan your PC for certain file types i.e. ‘xls’, ‘jpg’ . ‘avi’ etc and list the results in column ‘A’.
<o></o>
Ideally the macro should prompt you for the Drive letter and the file type (or file types if not too complicated) and list the files and the directories their in column ‘A’ e.g. C:\data\smile.jpg
<o></o>
<o></o>
Any assistance in this matter would be greatly appreciated
<o></o>
<o></o>
Many thanks
<o></o>
<o></o>
Rob
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>What I’m after is a macro that will scan your PC for certain file types i.e. ‘xls’, ‘jpg’ . ‘avi’ etc and list the results in column ‘A’.
<o
></o>Ideally the macro should prompt you for the Drive letter and the file type (or file types if not too complicated) and list the files and the directories their in column ‘A’ e.g. C:\data\smile.jpg
<o
></o><o
></o>Any assistance in this matter would be greatly appreciated
<o
></o><o
></o>Many thanks
<o
></o><o
></o>Rob
