🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

passing a variable into a file path

#494
From: lex comber
Date: Thu, 03 Jun 1999 00:00
47 lines
1991 bytes
This is a multi-part message in MIME format.
--------------BA065179D94536DDEBB8C524
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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

--------------BA065179D94536DDEBB8C524
Content-Type: text/x-vcard; charset=us-ascii;
 name="l.comber.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for lex comber
Content-Disposition: attachment;
 filename="l.comber.vcf"

begin:vcard 
n:Comber;Lex 
tel;fax:+44 (0)1224 311556
tel;work:+44 (0)1224 318611
x-mozilla-html:FALSE
url:http://www.mluri.sari.ac.uk/
org:Macaulay Land Use Research Institute;Land Use Science
version:2.1
email;internet:l.comber@mluri.sari.ac.uk
adr;quoted-printable:;;Craigiebuckler,=0D=0A;Aberdeen,;;AB15 8QH;
fn:Lex Comber
end:vcard

--------------BA065179D94536DDEBB8C524--
Technical Details
Message-ID: <375646F9.B69F03FE@mluri.sari.ac.uk>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1053fc,127dc2f266373ae,start
X-Google-Attributes: gid1053fc,public
X-Google-Thread: 110e3b,127dc2f266373ae,start
X-Google-Attributes: gid110e3b,public
From: lex comber <l.comber@mluri.sari.ac.uk>
Subject: passing a variable into a file path
Date: 1999/06/03
Message-ID: <375646F9.B69F03FE@mluri.sari.ac.uk>
X-Deja-AN: 485201041
X-Accept-Language: en
Content-Type: multipart/mixed; boundary="------------BA065179D94536DDEBB8C524"
Organization: Land Use Science Group, Macaulay Land Use Research Institute, Aberdeen,  AB15 8QH
Mime-Version: 1.0
Newsgroups: comp.lang.basic.visual.misc,es.comp.lenguajes.visual-basic