Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP on this strange errror : Method OpenTextFile of IFilesystem3
Can this user open the file. Find the file in windows explorer and try to
open it. They may not have access to open this file. If they can open it then do they have the same drive mapping to get to the file. For example your G: drive might be their H: drive. If this is the case you will have to use the full path, not just the local mapping. For example \\MyServer\MyDirectory... HTH "Learner" wrote: 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..... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP on this strange errror : Method OpenTextFile of IFilesystem3 Failed
This might help:
http://www.officekb.com/Uwe/Forum.as...rors/1288/IFil eSystem3 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP on this strange errror : Method OpenTextFile of IFilesystem3
Thanks Jim!
I dont think this is the issue because the user has access to the txt file the code is trying to open. Also, as you suggested its already in \\Shareserver\Sharefolder\Sharefile.txt format |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |