Advanced Excel - Object variable or With block variable not set (Error 91)??

Hi Larry,

Thanks for sharing a variation of Ron de Bruin's zip/unzip VBA code. He does awesome stuff. For anyone else who is interested:
Zip: http://www.rondebruin.nl/win/s7/win001.htm
UnZip: http://www.rondebruin.nl/win/s7/win002.htm

I think you may have bad input.

When I use your code exactly as is and the contents of cell A3 is xxxx.zip I get the same runtime error as you.

When the contents of A3 contains a path, then the code works for me e.g. C:\Users\Owner\Documents\xxxx.zip

I also get runtime error 91 when the value of strTargetPath is a path that does not exist.

Lewis