Re: VBA: LOF maximum lengte 2048 ?

Article View: be.comp.programming

Article #6967

Back to be.comp.programming Previous Next

#6967

From: Bart Vanwijnsberghe
Date: Mon, 28 Oct 2002 18:55

28 lines
2107 bytes

"barvok"...
> je zou dit kunnen doen met het FileSystemObject
> Leg een reference naar Microsoft Scripting Runtime (scrrun.dll)
> dan...
> Function GetFile as string
> dim fs as new filesystemobject
> dim ts as textstream
> dim strTekst as string
> 
> set ts=fs.opentextfile("mijnfile.txt")
> do until ts.atendofstream
> strtekst = ts.readline 
> loop
> 
> getfile = strtekst 
> ts.close
> set ts=nothing
> set fs=nothing
> end Sub
> 
> Probeer dit eens?

Ook hier krijg ik dezelfde foutmelding, vanaf meer dan 2048 tekens :-(
-- 
Bart Vanwijnsberghe
http://www.lightning.be
MSN: b_vanwijnsberghe@hotmail.com
ICQ: 49454469

Technical Details

Message-ID: <0Lfv9.183287$8o4.29101@afrodite.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!opentransit.net!proxad.net!skynet.be!skynet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail

References: <bmYt9.177078$8o4.28363@afrodite.telenet-ops.be> <MPG.1823aa2fd18c2eea98968c@news.pandora.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,dc7e0de2aed95b63
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,dc7e0de2aed95b63
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2002-10-28 12:56:17 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!opentransit.net!proxad.net!skynet.be!skynet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail
Reply-To: "Bart Vanwijnsberghe" <bartvanwijnsberghe@DELETE!!SPAMyahoo.com>
From: "Bart Vanwijnsberghe" <bartvanwijnsberghe@DELETE!!SPAMyahoo.com>
Newsgroups: be.comp.programming,nl.comp.programmeren
References: <bmYt9.177078$8o4.28363@afrodite.telenet-ops.be> <MPG.1823aa2fd18c2eea98968c@news.pandora.be>
Subject: Re: VBA: LOF maximum lengte 2048 ?
Lines: 28
MIME-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4920.2300
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300
Message-ID: <0Lfv9.183287$8o4.29101@afrodite.telenet-ops.be>
Date: Mon, 28 Oct 2002 18:55:56 GMT
NNTP-Posting-Host: 213.119.23.25
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1035831356 213.119.23.25 (Mon, 28 Oct 2002 19:55:56 MET)
NNTP-Posting-Date: Mon, 28 Oct 2002 19:55:56 MET
Organization: Telenet Internet

Reply to Parent Message