Import field form win explorer

  • Thread starter Thread starter andrew.ewing
  • Start date Start date
A

andrew.ewing

Is there a way to import the "title" field from windows explorer, so
that I can put it into excel? I have figured how to do this with the
filename field, but cant seem to import the "title" field.

Thanks
Andrew
 
Is there a way to import the "title" field from windows explorer, so
that I can put it into excel? I have figured how to do this with the
filename field, but cant seem to import the "title" field.

Thanks
Andrew
Click to expand...


What exactly do you mean? From what and how are you exporting the "filename"
field?
 
Im exporting the filename field from windows explorer by using a .bat
file to create a text file.From that text file i can import it into
excel. It does this by using a switch for the DIR command in dos. There
is no switch for the DIR command that allows you to view the title
field for windows explorer so this method wouldnt work. Just checking
to see if anyone else has been able to come up with a way of doing
this?

Thanks
 
Im exporting the filename field from windows explorer by using a .bat
file to create a text file.From that text file i can import it into
excel. It does this by using a switch for the DIR command in dos.
There is no switch for the DIR command that allows you to view the
title field for windows explorer so this method wouldnt work. Just
checking to see if anyone else has been able to come up with a way of
doing this?

Thanks
Click to expand...

Is there a reason you are not using VBA to do this ?
 
Only because im not to familiar with it and wouldnt know where to
start. Maybe ill check into and see if i can figure it out.

Thanks for the recommendation
 
Only because im not to familiar with it and wouldnt know where to
start. Maybe ill check into and see if i can figure it out.

Thanks for the recommendation
Click to expand...

Here's a link to listing file's in a directory and plugging them into an
Excel spreadsheet. This sample does NOT show 'Title', 'Author', blah....

http://www.exceltip.com/st/List_files_in_a_folder_with_Microsoft_Scripting_
Runtime_using_VBA_in_Microsoft_Excel/446.html

I included this link because it shows putting the results in to Excel
directly.

The below link is a VBS for showing the extended info, 'Title', 'Author',
blah....

http://www.codecomments.com/VBScript/message410755.html

Between these two pieces of code, you should very easily be able to do
exactly what you are looking for. Just piece them together to get what you
need.
 
Awesome, thanks alot!
DanS said:
Here's a link to listing file's in a directory and plugging them into an
Excel spreadsheet. This sample does NOT show 'Title', 'Author', blah....

http://www.exceltip.com/st/List_files_in_a_folder_with_Microsoft_Scripting_
Runtime_using_VBA_in_Microsoft_Excel/446.html

I included this link because it shows putting the results in to Excel
directly.

The below link is a VBS for showing the extended info, 'Title', 'Author',
blah....

http://www.codecomments.com/VBScript/message410755.html

Between these two pieces of code, you should very easily be able to do
exactly what you are looking for. Just piece them together to get what you
need.
Click to expand...
 
Back
Top