Re: Writing records to CSV file

You can write a file as large as you want (limited by harddrive space???).

But the question is how will the recipient use that file. If it's too large for
you to open in xl2003, then it'll be too big for the recipient, too.

Depending on what you want, you could write to multiple .csv files and limit
their line count to less than 64k.

Then the recipient could open each .csv file into a new worksheet or new
worksheet in a new workbook.



Ken Warthen wrote:

Dave,

The user will be using Excel 2003. If I can write the records into an xlCSV
file, I thought the row limitation will not apply.

Ken

"Dave Peterson" wrote:

Maybe the recipient has xl2007 (with 1MB rows).

Or maybe the .csv files will be split into smaller pieces some how????

"Just Another Yahoo!" wrote:

Maybe I'm missing something (and please correct me if so) but if the workbook
is too big to export as .csv, then won't it be too big to import into Excel
for the reviewer as well, regardless of how you save it (as either a workbook
or .csv)?
--
Toby Erkson
Excel 2003, WinXP

"Ken Warthen" <KenWarthen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:97FF07EA-CDAA-4EFF-BA57-F2538E0839F0@xxxxxxxxxxxxxxxx
Jennifer,

I actually need to use the xlCSV file format as one of the endusers will be
reviewing the file in Excel before its data is uploaded to a mainframe
application.

Ken

--

Dave Peterson


--

Dave Peterson
.

Relevant Pages

  • Re: Opening then saving a CSV file looses Commas in Excel 2003
    ... From an Excel ... >> Dave Peterson wrote: ... >>> Column Delimiters Missing in Spreadsheet Saved as Text ... >> that in order for them to get CSV files to work in Excel correctly they ...
    (microsoft.public.excel)
  • Re: How can i import multiple .csv files into Excel for analysis?
    ... I never considered reverting back to good old DOS. ... "Dave Peterson" wrote: ... > I'd shell to DOS and then copy all the .csv files to one .csv file on my ... >> I need to copy multiple .csv files into Excel so that i can analyse the ...
    (microsoft.public.excel.programming)
  • Re: Transfer CSV file from Winzip to Excel
    ... settings applet than what shows up in those .csv files, ... I use comma to separate my fields. ... If you have your data in excel already (each worksheet has just one used column, ... >> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: How do I import several csv files into one excel worksheet?
    ... There is a check in there that the folder contains csv files, ... Dave Peterson Wrote: ... 'Open the TXT file in Excel ...
    (microsoft.public.excel.misc)
  • Re: how do I email amacro?
    ... recipient. ... Most users of excel wouldn't know what to do with the text of a ... mr_ben's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37106 ... Dave Peterson ...
    (microsoft.public.excel.worksheet.functions)