check if your problematic user can open the file from their computer.

Maybe they don't have permissions to that file.

--
Regards,
Tom Ogilvy

"Learner" <tomjcb@gmail.com> wrote in message
news:1109180614.658466.127490@g14g2000cwa.googlegroups.com...
> I have a VBA macro on MS Excel that should open and read from a Text
> file. This is the code
>
>
> Dim fs, Tempfile
> Set fs = CreateObject("Scripting.FileSystemObject")
> Set TempFile = fs.OpenTextFile(strInputFile, 1, False)
> Do While TempFile.AtEndOfLine <> True
> ' Process
> Loop
>
>
> I found that it throws error in the OpenTextFile mothod above..
>
>
> It works for all of our users but one. One guy is getting this strange
> error meesage when the code executes. I checked his MS excel and found
> its same as mine, Office 2003 SP1 (The code works fine in my machine).
>
>
> Can you GURUS please help me on this.....
>