Article View: comp.lang.basic.visual.misc
Article #494passing a variable into a file path
From: lex comber
Date: Thu, 03 Jun 1999 00:00
Date: Thu, 03 Jun 1999 00:00
47 lines
1991 bytes
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-mailShow 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