Is there any way to detect whether a workbook has been opened from within a zip file?
I have a XLSM workbook which is distributed inside a zip. I need the end users to extract the zip file before starting a calculation in the workbook. However I currently have no way of enforcing this. If I had a function that could return whether the file is inside a zip (or not) then I could display a MsgBox and force the workbook to close.
I have two ideas on how this might be done:
1. 'Read Only status'? I don't know much about this. Is an Excel workbook treated as read-only if opened from a Zip file?
2. Workbook file path? Check to see if the workbook path = a temporary folder path on Windows? (The end users would all be using Windows).
Bookmarks