Trent, glad you liked the idea--you must have a little Rube Goldberg in you
<g.
Regards,
Shockley
"Trent Argante" wrote in message
...
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
-----Original Message-----
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" wrote in message
...
(Windows NT & Excel 97)
Does anyone know of a way to return the current
directory
being viewed by Windows Explorer to Excel?
Thanks.
Trent
.