File Path Issue

[shabar]

Hi All

I a have following path in my code. There J is a mapping drive



FileName = "J:\Business Projects\Ancillary\T1.txt"

Shell """" & FileName & """"


Even with the above it gives file not found run time error 53

What could be the reason


Cheers

Shabar

[NTC]

One thing: you are using the syntax with """" as if filename is a control on a form. if file name is being defined as a string variable in your vba stack of code you would not need the quotation marks.....

maybe helps a little....

[shabar]

Hi NTC

Thax for your reply

But even without that (after removing Shell ....) it doesn't work


cheers

shabar

[shabar]

This issue is occurring when the file is in mapping drive. In my case file should be there

So is there any resolution for this type of scenarios



Cheers

Shabar

[pirabkao]

This issue is occurring when the file is in mapping drive. In my case file should be there

So is there any resolution for this type of scenarios



Cheers

Shabar

This might work. Try changing the code --> FileName = "J:\Busines~1\Ancillary\T1.txt"

[shabar]

This might work. Try changing the code --> FileName = "J:\Busines~1\Ancillary\T1.txt"

Unfortunately even this doesn't work.

Is it possible to add the text file to the VB project. I tried but its adding as a Module


Cheers

shabar