Prev: web components - msowc.dll
Next: Microsoft Office Excel is waiting for another application to complete an OLE action
From: Learner on 22 Feb 2005 16:20 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..... |