Whenever I click on a hyperlink inside an Excel cell such as
file:///\\mynetwork\folder\test.zip
OR
\\mynetwork\folder\test.zip
then the file would be opened with the built-in zip viewer.
Is it possible to use VBA (or something else) such that it pop-up a Save As dialog so that we can save the file instead of opening it? This is more convenient where we want to keep files from these network locations to the local hard drive.
file:///\\mynetwork\folder\test.zip
OR
\\mynetwork\folder\test.zip
then the file would be opened with the built-in zip viewer.
Is it possible to use VBA (or something else) such that it pop-up a Save As dialog so that we can save the file instead of opening it? This is more convenient where we want to keep files from these network locations to the local hard drive.
Facebook
Twitter