"DIR" Command not working

[Mackeral]

Using Office 365 Excel

I enter into Immediate Box

Dir ("E:")

and I get back "180601 Temp RIBBON CALLS.BAS" which isn't even a file in E:.

I add

Dir ("E:*.*)"

and I get bck the same thing.

If I use

Dir("E:*.Bat")

Nothing shows but there is one "*.Bat" file in the directory.

Any idea of what's going on here?

Thanks,
Mac

 

[Scott Huish]

For sure you're going to have a problem because you are missing the \

 

[Mackeral]

When I do "Dir("c:\Program Files")", i get back is "- Program Files.lnk". And
"C:\*.* "
gives back
".crusader"
when there are 3 other files there.

It use to give me a list of all the files. What's happening?

But thanks for the reply.
Mac

 

[Eric W]

Dir only gives you 1 file at a time. To see all of them, you need to use it in a loop, like this:

    str1 = Dir("C:\Folder\*.*")
    While str1 <> ""
        Debug.Print str1
        str1 = Dir()
    Wend