open用法 vba_Open 环境下 False 与 True 的用法

本帖最后由 张雄友 于 2015-2-12 18:08 编辑

Open 环境下 False 与 True 的用法，近段时间读了很多遍历文件的例子，

有个疑问：什么时候用wb.Close True，什么时候用 wb.Close False  ？http://club.excelhome.net/forum.php?mod=viewthread&tid=843771&extra=page%3D1%26filter%3Dtypeid%26typeid%3D16%26typeid%3D16

http://club.excelhome.net/thread-1186910-1-1.html

Sub 删除空行()

Dim sh As Worksheet, w As WorksheetFunction, Filepath, LastRow As Long, NowRow As Long, MyPath$

With Application.FileDialog(msoFileDialogFolderPicker)

.InitialFileName = ThisWorkbook.Path & "\"

If .Show = False Then Exit Sub

MyPath = .SelectedItems(1) & "\"

End With

Application.DisplayAlerts = False

Application.ScreenUpdating = False

Set d = CreateObject("scripting.dictionary")

Set w = Application.WorksheetFunction<