Problems with Macro to convert to CSV
 

have an excel file which I want to convert to a csv. THe
macro works fine except the resulting csv file has all
these extra commas both below and to the right of the
values.

Tried deleting the blank values below and to the right
but still no luck.

Any suggestions?

Problems with Macro to convert to CSV
 

Jonathan,

Press <Ctrl+<End keys together. Where do you end up?
After deleting excess rows or columns, save the file to reset the last cell.

Test again to see where the end cell is.

regards,

JohnI

"Jonathan" wrote in message
...
have an excel file which I want to convert to a csv. THe
macro works fine except the resulting csv file has all
these extra commas both below and to the right of the
values.

Tried deleting the blank values below and to the right
but still no luck.

Any suggestions?

Problems with Macro to convert to CSV
 

I assume you mean within the source file as opposed to
the csv file.

In the source file it ends up at cell CA19993. when i
delete all the rows last cell is where it should be and
no extra commas. however i have tried this before
(deleting every row and column aside from the numbes) and
it didnt work.

what does this mean?

thanks for your help.
-----Original Message-----
Jonathan,

Press <Ctrl+<End keys together. Where do you end up?
After deleting excess rows or columns, save the file to
reset the last cell.

Test again to see where the end cell is.

regards,

JohnI

"Jonathan" wrote in message
...
have an excel file which I want to convert to a csv.
THe
macro works fine except the resulting csv file has all
these extra commas both below and to the right of the
values.

Tried deleting the blank values below and to the right
but still no luck.

Any suggestions?



.

Problems with Macro to convert to CSV
 

Perhaps you didn't do it correctly.

assume you actual data is in A1:Z500

go to the name box in the upper left (should show the currently selected
cell like A1)

enter
501:65536<cr
this will select the entire rows, now do Edit=Delete

back to the name box, enter
AA:IV<cr
this will select the entire columns. Now do Edit=Delete

No save the file (as a normal worksheet file). This will cause excel to
interpret you deletions and reset the used region.

<cr means to hit the enter key just to be clear.

--
Regards,
Tom Ogilvy

Jonathan wrote in message
...
I assume you mean within the source file as opposed to
the csv file.

In the source file it ends up at cell CA19993. when i
delete all the rows last cell is where it should be and
no extra commas. however i have tried this before
(deleting every row and column aside from the numbes) and
it didnt work.

what does this mean?

thanks for your help.
-----Original Message-----
Jonathan,

Press <Ctrl+<End keys together. Where do you end up?
After deleting excess rows or columns, save the file to
reset the last cell.

Test again to see where the end cell is.

regards,

JohnI

"Jonathan" wrote in message
...
have an excel file which I want to convert to a csv.
THe
macro works fine except the resulting csv file has all
these extra commas both below and to the right of the
values.

Tried deleting the blank values below and to the right
but still no luck.

Any suggestions?



.

Problems with Macro to convert to CSV
 

that fixed it, thanks.
-----Original Message-----
Perhaps you didn't do it correctly.

assume you actual data is in A1:Z500

go to the name box in the upper left (should show the
currently selected
cell like A1)

enter
501:65536<cr
this will select the entire rows, now do Edit=Delete

back to the name box, enter
AA:IV<cr
this will select the entire columns. Now do Edit=Delete

No save the file (as a normal worksheet file). This
will cause excel to
interpret you deletions and reset the used region.

<cr means to hit the enter key just to be clear.

--
Regards,
Tom Ogilvy

Jonathan wrote in message
...
I assume you mean within the source file as opposed to
the csv file.

In the source file it ends up at cell CA19993. when i
delete all the rows last cell is where it should be and
no extra commas. however i have tried this before
(deleting every row and column aside from the numbes)
and
it didnt work.

what does this mean?

thanks for your help.
-----Original Message-----
Jonathan,

Press <Ctrl+<End keys together. Where do you end up?
After deleting excess rows or columns, save the file
to
reset the last cell.

Test again to see where the end cell is.

regards,

JohnI

"Jonathan" wrote in message
...
have an excel file which I want to convert to a csv.
THe
macro works fine except the resulting csv file has
all
these extra commas both below and to the right of
the
values.

Tried deleting the blank values below and to the
right
but still no luck.

Any suggestions?



.



.