Re: passing a variable into a file path

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

Article #496

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

#496

From: Eelco Mulder
Date: Thu, 03 Jun 1999 00:00

8 lines
999 bytes

Workbooks.OpenText FileName:="I:\ncms\squares\" + i + ".dat"

is so wrong because VB uses a '&' to glue things, you have to use

Workbooks.OpenText FileName:="I:\ncms\squares\" & i & ".dat"

Eelco Mulder
EMulder at Ravelin.NL

Technical Details

Message-ID: <7j5oo7$imc$1@zonnetje.NL.net>

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: "Eelco Mulder" <EMulder@Ravelin.NL>
Subject: Re: passing a variable into a file path
Date: 1999/06/03
Message-ID: <7j5oo7$imc$1@zonnetje.NL.net>
X-Deja-AN: 485226733
References: <375646F9.B69F03FE@mluri.sari.ac.uk>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: abuse@nl.uu.net
X-Trace: zonnetje.NL.net 928409159 19148 212.136.247.170 (3 Jun 1999 11:25:59 GMT)
Organization: UUNET-NL (http://www.nl.uu.net)
NNTP-Posting-Date: 3 Jun 1999 11:25:59 GMT
Newsgroups: comp.lang.basic.visual.misc,es.comp.lenguajes.visual-basic

Reply to Parent Message