Re: passing a variable into a file path

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

Article #495

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

#495

From: Fedor Solodovnik
Date: Thu, 03 Jun 1999 00:00

32 lines
1587 bytes

"I:\ncms\squares\" & str(i) & ".dat"

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
> 
>   ------------------------------------------------------------------------
> 
>                          Name: l.comber.vcf
>    l.comber.vcf          Type: VCard (text/x-vcard)
>                      Encoding: 7bit
>                   Description: Card for lex comber

-- 
Mailto:fsolodov@ntmail.desy.de

Technical Details

Message-ID: <37566D82.36F41928@ntmail.desy.de>

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: Fedor Solodovnik <fsolodov@ntmail.desy.de>
Subject: Re: passing a variable into a file path
Date: 1999/06/03
Message-ID: <37566D82.36F41928@ntmail.desy.de>
X-Deja-AN: 485220451
Content-Transfer-Encoding: 7bit
References: <375646F9.B69F03FE@mluri.sari.ac.uk>
To: lex comber <l.comber@mluri.sari.ac.uk>
Content-Type: text/plain; charset=us-ascii
Organization: DESY
Mime-Version: 1.0
Newsgroups: comp.lang.basic.visual.misc,es.comp.lenguajes.visual-basic

Reply to Parent Message