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?

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?

"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.