Thread: Extra trailing commas in exported CSV
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Extra trailing commas in exported CSV
You have another response at your original thread.

lucidr wrote:

Hi All

I have some VBA that exports a sheet from my workbook as a CSV file. I
do some cleaning up on the sheet before it is exported:

wksCSV.Range("H2:AA65536").Clear
wksCSV.Range("A2:AA65536").ClearFormats

Despite this I consistently get two extra trailing commas on rows 2 to
16 (first row is a header, which is longer) in the resulting CSV (as if
H2:I16 contained something). Any suggestions?

--
lucidr
------------------------------------------------------------------------
lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699
View this thread: http://www.excelforum.com/showthread...hreadid=564635

--

Dave Peterson
Reply With QuoteReply With Quote