Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Method Add of object Validation Failed - please help | Excel Worksheet Functions | |||
Method failed when creating new worksheets | Excel Programming | |||
Copypicture method failed | Excel Programming | |||
Calculation Method Failed | Excel Programming | |||
Method ~ of Object ~ Failed. | Excel Programming |