using Dir function parameters?

[Luis939]

hey if i have these statements:

MyFile = Dir("C:\", vbNormal)

is there anyway where i can just use the path again but refering it as the first parameter of Dir. If i have a very long path, i wouldnt want to write it out again, is there a simple of way of just using whatever is the first argument for the Dir function? thanks!!

 

[xlbo]

why not just assign it to a string variable ???

dim mPath as string

mPath = "C:\Home\My Docs\This\And\That\Stuff\"

then you can use
MyFile = Dir(mPath, vbNormal)
and use mPath to refer to that path for the rest of the procedure

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244