确定是否曾经保存过Excel工作簿? [英] Determine if an Excel workbook has ever been saved?

问题描述

如何使用VBA判断是否保存过Excel工作簿?

How can I tell, using VBA, if an Excel workbook has ever been saved?

我想知道单击保存"会将文档保存到现有位置还是提示我选择一个保存位置.

I want to know if clicking save will save the document to an existing location or prompt me to choose a save location.

推荐答案

If ActiveWorkbook.Path = vbNullString Then
    'actions if the active workbook hasn't been saved yet go here
Else
    '....
End If

这篇关于确定是否曾经保存过Excel工作簿?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！