|
Scott,
I would have to say based on your confirmation that the
variable does in fact contain what you expect it to that as simple as it sounds
you may want to check to make sure the file you are looking for is in the
directory you are expecting it in and that it is spelled
correctly.
You indicate when you change it back it works, well when
you change it back it is a different file name according to your code sample
unless I am being to literal in the interpretation of your
code.
Thanks,
Corinna Robertson
Boston Software Systems
The
Essential Tool for Healthcare Integration
866-653-5105 ext. 8
508-653-5105
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of White, Scott A Sent: Thursday, October 28, 2004 2:30 PM To: [EMAIL PROTECTED] Subject: [Talk] File not found Hello
everyone,
I've got a script that's been running fine
until I tried to modify one statement.
I changed this
statement:
strArrayFileName = View(Row:=5, Col:=25,
Length:=21) 'C:\ARRAY\20030411.TXT
to this: strArrayFileName = View(Row:=5, Col:=25,
Length:=17) & Facility & ".txt"
'C:\ARRAY\20030411
Then when I get to this point in the
script it errors out with Error 53 - File not
found.
Sub Parse(Optional dummy As String)
Dim F As Integer Dim G As Integer Dim S As String F = FreeFile Open strArrayFileName For Input As F '**** I GET THE ERROR - FILE NOT FOUND... 10/28/04 If LOF(F) < Len(Rec) Then Stop 'no source file But if I put the original statement back
in, which only captures the file info on the screen, it is
fine.
I watched the Locals and saw that
strArrayFineName was getting the correct assignment of
C:\ARRAY\20030411SSC.TXT even
when getting the error File not found.
Any
ideas?
Thanks
again,
Scott
|
<<image001.jpg>>
