dir is a special stream in the VBA Project binary, and by default, in Excel and Word, the VBE won't let you name a module dir.
Access (and maybe other hosts), abstract the module name from the stream name, so dir is actually permitted, but it's still not a great choice of name (as it conflicts with VBA.FileSystem.Dir)
ThunderFrame
commented
7 years ago
diris a special stream in the VBA Project binary, and by default, in Excel and Word, the VBE won't let you name a moduledir.Access (and maybe other hosts), abstract the module name from the stream name, so
diris actually permitted, but it's still not a great choice of name (as it conflicts withVBA.FileSystem.Dir)