Re: passing a variable into a file path

Article View: comp.lang.basic.visual.misc

Article #493

Back to comp.lang.basic.visual.misc Previous Next

#493

From: Jon Helms
Date: Fri, 04 Jun 1999 00:00

28 lines
1690 bytes

This has been well answered already, but for future reference it would
be helpful if you tell us how you are getting stuck, does it give an
error message when you try "play" it in the IDE, does it give a RTE? 
Also the specific error message is helpful.

Jon

lex comber wrote:
> 
> Apologies for the cross postings...
> 
> A simple bit of advice for a novice needed:
> 
> I have a list of files "0.dat" to "255.dat"
> I am trying to pass a variable into a string to open a series of files
> and am getting stuck on the line
> 
>     (For i = 0 To 255)
>     Workbooks.OpenText FileName:="I:\ncms\squares\" + i + ".dat",
> Origin:= _
>         xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=...
>     (...etc..
>     Next i )
> 
> Any suggestions gratefully received
> 
> Lex Comber

Technical Details

Message-ID: <3757D023.3C53AADA@purdue.edu>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <375646F9.B69F03FE@mluri.sari.ac.uk>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1053fc,127dc2f266373ae
X-Google-Attributes: gid1053fc,public
X-Google-Thread: 110e3b,127dc2f266373ae
X-Google-Attributes: gid110e3b,public
From: Jon Helms <helmsjr@purdue.edu>
Subject: Re: passing a variable into a file path
Date: 1999/06/04
Message-ID: <3757D023.3C53AADA@purdue.edu>
X-Deja-AN: 485655167
Content-Transfer-Encoding: 7bit
References: <375646F9.B69F03FE@mluri.sari.ac.uk>
To: lex comber <l.comber@mluri.sari.ac.uk>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@mozo.cc.purdue.edu
X-Trace: mozo.cc.purdue.edu 928501575 28730 128.210.111.95 (4 Jun 1999 13:06:15 GMT)
Organization: Purdue University
Mime-Version: 1.0
NNTP-Posting-Date: 4 Jun 1999 13:06:15 GMT
Newsgroups: comp.lang.basic.visual.misc,es.comp.lenguajes.visual-basic

Reply to Parent Message