ExcelBanter - Opening zipped/compressed files

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Opening zipped/compressed files (https://www.excelbanter.com/excel-programming/361151-opening-zipped-compressed-files.html)

JohnUK

Opening zipped/compressed files

Hi,
I have another problem (Challenge for someone)
I have lots of zipped files (Windows XP compressed folders) in My Documents
folder that are Date and Time tagged. I need a piece of code to locate the
latest zipped file and then open.
Again €“ any help much appreciated
Regards
John

Ron de Bruin

Opening zipped/compressed files

See
http://www.rondebruin.nl/windowsxpzip.htm

Try this to unzip
http://www.rondebruin.nl/files/windowsxpunzip.txt

--
Regards Ron de Bruin
http://www.rondebruin.nl

"JohnUK" wrote in message ...
Hi,
I have another problem (Challenge for someone)
I have lots of zipped files (Windows XP compressed folders) in My Documents
folder that are Date and Time tagged. I need a piece of code to locate the
latest zipped file and then open.
Again - any help much appreciated
Regards
John

JohnUK

Opening zipped/compressed files

Many thanks Ron.
A star as always

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/windowsxpzip.htm

Try this to unzip
http://www.rondebruin.nl/files/windowsxpunzip.txt

--
Regards Ron de Bruin
http://www.rondebruin.nl

"JohnUK" wrote in message ...
Hi,
I have another problem (Challenge for someone)
I have lots of zipped files (Windows XP compressed folders) in My Documents
folder that are Date and Time tagged. I need a piece of code to locate the
latest zipped file and then open.
Again - any help much appreciated
Regards
John

All times are GMT +1. The time now is 03:08 AM.