(Help) Dir Function in Module..

[TRENDcafe]

hello guys..

i tried this code in my module

Public Const sPath As String = Dir("C:\Sample.txt", vbNormal Or vbHidden)

and got this error:

Constant Expression Required

what should i do.?

thnx in advance..

[dee-u]

You just need to modify it like this.

Public sPath As String 
SPath = Dir("C:\Sample.txt", vbNormal Or vbHidden)

[westconn1]

as you call it sPath, note the return from dir is filename only

[Hack]

I suspect you are using VB.NET and not VB6. Is that an accurate supposition?

[RhinoBull]

If "c:\sample.txt" file will always be there then you can define your constant like this:

Public Const SAMPLE_FILE As String = "C:\Sample.txt"

Change scope to Private if you want to declare it in the form.

[dee-u]

Dir("C:\Sample.txt", vbNormal Or vbHidden) will not be constant hence you cannot use it in your constant declaration.

[TRENDcafe]

wow.. thank to all of u guys...

@dee-u: thnx for ur reply sir,, ah so it means i cannot use that as a constant?

@westconn1: thnx u sir,, yup i am aware of that..hehehe

@Hack:i am using VB6 sir,,i just trying to make that as constant but i think i cant.

@RhinoBull: nope the "C:\sample.txt" may be there but its hidden, thats why i use Dir to check sir..hehe

@dee-u: thank u sir,, its clear to me now..hehehe