Win Explorer to Excel

[Trent Argante]

(Windows NT & Excel 97)
Does anyone know of a way to return the current directory
being viewed by Windows Explorer to Excel?
Thanks.
Trent

 

[shockley]

One way:
You could launch a script program like AutoIt which has a command that will
return the active window. You would then have Autoit save this information
in a text file and have Excel open, read, and close the text file.
http://www.hiddensoft.com/AutoIt/

Shockley

 

[Trent Argante]

Shockley,
This is truly a great suggestion, which I will definitely
consider for home.
But, I don't want to go through the Admin red tape of
having it installed on my system at work.
Thanks for the help.
Trent

 

[shockley]

Trent, glad you liked the idea--you must have a little Rube Goldberg in you
<g>.

Regards,
Shockley

 

[shockley]

Rube Goldberg is more about doing things in absurdly complicated fashion,
rather than making the most efficient machine--which is how I feel about
some of my vba+Autoit creations, but at the point I'm doing them it's the
only way I know. But your point is well taken, seeing as a lot of software
is entirely about automating task drudgery--and I often ask myself why
didn't I do it right the first time?? when I notice how much manual labor I
could have been avoiding.

Regards,
Shockley