Skip to content

Instantly share code, notes, and snippets.

@tamago324
Created October 4, 2017 05:20
Show Gist options
  • Save tamago324/93ce38343416605b73bab0597b4dd490 to your computer and use it in GitHub Desktop.
Save tamago324/93ce38343416605b73bab0597b4dd490 to your computer and use it in GitHub Desktop.
フォルダが存在しているか - VBA
If Dir("C:\temp", vbDirectory) <> "" Then
Workbooks.Open "C:\temp"
Else
MsgBox "C:\temp" & vbCrLf & "が存在しません"
End If
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment