Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs CSV file size
i have written a macro that will save a nominated worksheet as a CSV
my problem is that when i have only one record in the worksheet i.e. Header 1, Header 2, Header 3 content 1, content 2, content 3 the CSV file size blows out to 1,281Kb however when there is more than one record in the worksheet i.e. Header 1, Header 2, Header 3 content 1, content 2, content 3 content 1, content 2, content 3 the file size drops back to 1kb where is should be. has anybody experienced this before? how can i ensure the file size is kept to a minimum? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Confused here Prevent Saving File - but allow ONLY File SAVEAS Met | Excel Discussion (Misc queries) | |||
saveas CSV file | Excel Discussion (Misc queries) | |||
How can I make File-Save , File-SaveAs Menu disabled? | Excel Programming | |||
Saveas csv file | Excel Programming | |||
File SaveAs | Excel Programming |