View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Learner[_3_] Learner[_3_] is offline
external usenet poster
 
Posts: 14
Default HELP on this strange errror : Method OpenTextFile of IFilesystem3 Failed

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

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.....