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?

SaveAs CSV file size
 

Are you using end down in your macro starting at row 2? My guess is that your
code is specifying the blank cells down to the bottom of the sheet.
--
Tony Green


"7zark7" wrote:

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?

SaveAs CSV file size
 

"ADG" wrote:

Are you using end down in your macro starting at row 2? My guess is that your
code is specifying the blank cells down to the bottom of the sheet.
--
Tony Green


"7zark7" wrote:

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?


hahaha, i am, thanks i will change it to a loop. that should resolve the
issue.