Re: file directory with creation date & dimensions (for photo list

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



You're welcome Kristine. BTW, I've modified David's code little bit. Creates
a file named "ExtendedFileList.txt" in the same folder for which you run the
listing. Automatically opens the Tab de-limited text file in Microsoft
Excel.

- - - - -Script begins from next line- - - -

Set objShell = CreateObject("Shell.Application")
Set WshShell = CreateObject("Wscript.Shell")
Set Ag=Wscript.Arguments
Set Fldr=objShell.NameSpace(Ag(0))
Set FldrItems=Fldr.Items
Set fso = CreateObject("Scripting.FileSystemObject")
FName = FLDR.self.path & "\ExtendedFileList.txt"
Set ts = fso.OpenTextFile(FName, 2, vbtrue)
For x = 0 to 50
t1 = t1 & Fldr.GetDetailsOf(vbnull, x) & vbtab
Next
ts.write FLDR.self.path &vbcrlf
ts.Write T1 & vbcrlf
T1=""
For Each FldrItem in FldrItems
For x = 0 to 50
t1 = t1 & Fldr.GetDetailsOf(FldrItem, x) & vbtab
Next
t1=t1 & vbcrlf
ts.Write T1
T1=""
Next
ts.close

'If you don't have MS Excel, comment next line
'---------------------------------------------
WshShell.Run "excel.exe " & chr(34) & FName & chr(34), 1, True
Set objShell = Nothing
Set WshShell = Nothing
Set fso = Nothing

- - - - Script ends in previous line- - - -


--
Regards,

Ramesh Srinivasan, Microsoft MVP [Windows XP Shell/User]
Windows® XP Troubleshooting http://www.winhelponline.com


"Kristine the DragonLady" <KristinetheDragonLady@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:89606E4A-7A77-4695-BA48-76955C27C164@xxxxxxxxxxxxxxxx
Thanks Ramesh. It looks way too complicated, but I'll look through it.
--
JackRussellsRule!


"Ramesh, MS-MVP" wrote:

> Hi,
>
> This is possible using Windows Scripting
>
> From David Candy:
> http://groups.google.co.in/groups?selm=%23449C%24%24VEHA.1144%40TK2MSFTNGP10.phx.gbl
>
> Microsoft Windows 2000 Scripting Guide:
> http://www.microsoft.com/technet/scriptcenter/guide/sas_fil_lunl.mspx
>
> --
> Regards,
>
> Ramesh Srinivasan, Microsoft MVP [Windows XP Shell/User]
> Windows® XP Troubleshooting http://www.winhelponline.com
>
>
> "Kristine the DragonLady" <Kristine the
> DragonLady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:78085CF4-2CAD-4F73-98A4-7685BF20AADB@xxxxxxxxxxxxxxxx
> I've done a reasonably good search, but can't find what I need. I've
> downloaded Karen's Directory Printer... very good, but doesn't list the
> CORRECT creation date for my photos.
> Scenario: copied a batch of photos to cd, 2 so one can go offsite, checked
> the cds read/opened files ok, then deleted all (and emptied recycle bin...
> space needed). Didn't notice until I went to do dir list of the cd (to
> print
> & keep with cd) that the dates were those of when copied to cd. Can still
> see
> all properties in right-click, properties, summary but how the **** do I
> get
> this info into a listing? Can do command prompt DOS listings (a breeze),
> and
> import/edit in Excel, but still doesn't give the CORRECT creation date, or
> any info like dimensions, etc.
> Can anyone help, please?
>
>
>


.



Relevant Pages

  • Re: Virtual PC 7.0.2 on Tiger - Activation problem with Windows XP Pro
    ... I'm having problems with Excel files in Excel 2004 Mac where a ... tried downloading the Excel 2003 Windows trial, ... and although the trial can repair my Mac Excel ... Microsoft bug after microsoft bug. ...
    (microsoft.public.mac.virtualpc)
  • Re: Unrecognizable file format
    ... Windows Explorer to look at the file I saved to the hard drive. ... I have updated this same spreadsheet countless times in the past ... opened the Excel file 3 wks ago, it opened just fine like it always does. ... it shows the type as "Microsoft Excel Worksheet." ...
    (microsoft.public.excel.misc)
  • Re: Unrecognizable file format
    ... It still says file format not recognizable. ... Windows Explorer to look at the file I saved to the hard drive. ... opened the Excel file 3 wks ago, it opened just fine like it always does. ... it shows the type as "Microsoft Excel Worksheet." ...
    (microsoft.public.excel.misc)
  • Re: Unable to access Microsoft Office 2007 Excel after XP Updates
    ... After the latest round of Windows XP Home SP3 updates, ... Excel, I get "Windows cannot access the specified device, path, or file. ... I tried to "Repair" Microsoft Office through the control panel but it ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Excell and Word Hang up when attempting use Save As command
    ... there no direct Microsoft Support? ... It is Windows OS updates that did the deed. ... Gord Dibben MS Excel MVP ... Problems in Windows Explorer or the Windows shell after you install security ...
    (microsoft.public.excel)