Re: Smart way to delete the first row of a huge file
- From: Charles <spam@xxxxxxxxxxx>
- Date: Wed, 26 Mar 2008 11:20:04 -0700 (PDT)
Actually, not sure it works. Your code requires to load the whole
200MB file into memory in one go. Which would be probably faster than
having an access to the drive for each line read/written. But that's
going to be a big ask for Excel. Actually can a single string contain
200MB of data?
I actually have another question: I never really understood the
meaning of the "#" character before variables, or the "$" sign after
the name of the function. How different is it from simply using mid()
or filenum?
Charles
.
- Follow-Ups:
- Re: Smart way to delete the first row of a huge file
- From: Rick Rothstein \(MVP - VB\)
- Re: Smart way to delete the first row of a huge file
- References:
- Smart way to delete the first row of a huge file
- From: Charles
- Re: Smart way to delete the first row of a huge file
- From: Rick Rothstein \(MVP - VB\)
- Re: Smart way to delete the first row of a huge file
- From: Charles
- Smart way to delete the first row of a huge file
- Prev by Date: Re: Working with Cell Comments - VBA
- Next by Date: create shortcut but not for active workbook
- Previous by thread: Re: Smart way to delete the first row of a huge file
- Next by thread: Re: Smart way to delete the first row of a huge file
- Index(es):
Relevant Pages
|
