Problems with Macro to convert to CSV

[Jonathan]

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?

 

[JohnI in Brisbane]

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]

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.

 

[Tom Ogilvy]

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.

 

[Jonathan]

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




.