VBA如何以读取压缩文件的形式，读取EXCEL文件中的工作表名称，不能用OPEN方法

Question

VBA如何以读取压缩文件的形式，读取EXCEL文件中的工作表名称，不能用OPEN方法

Answer 1

Hi @仁江 朱,

As per my knowledge, if you want to get the worksheet name from a zip archive Excel file, you will need to extract the file first and then open it in Excel before running the code. I'm afraid we cannot directly get the name of the worksheet from a zip archive Excel file.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.