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

[larryg003]

Hi All,

I've been running this section of code without any problems for the past three months. Today, for the first time ever, Object variable or With block variable not set (Error 91)?

Please Login or Register  to view this content.

The code stopped running at:

Please Login or Register  to view this content.

Any ideas how to fix?

Thanks!

L

[LJMetzger]

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