Problems with Macro to convert to CSV

P

PTProgram

New Member
Joined
May 16, 2003
Messages
33
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.

Furtermore, sometimes the csv holds the date format of a column and sometimes it doesnt.

Any suggestions?
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Sort by date Sort by votes
Can you give sample of source file ?
Can you give sample of csv file ?
Can you give us a look at the macro ?
 
Upvote 0
I would like to but company I work for has clamped down on sending any company files out.

As for the macro, even when i do it manually step-by-step the same thing happens. The source file itself has no formulas, all hard-coded numbers, with one column of dates. Sorry I can't provide more,but someone just got in lots of trouble for sending company files out.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Extracting & Manipulating Data from CSV
Replies
4
Views
574
rlv01
R
R
  • Question
VBA Script: Saving worksheet as CSV on MacOS
Replies
1
Views
868
temphelp
T
H
  • Solved
Macro to convert Files into CSV Files-limit selection when browsing
Replies
1
Views
237
howard
H
H
  • Question
Macro to move csv files within-subfolder to folder "Old Templates"
Replies
2
Views
360
howard
H
J
  • Question
Cannot close temporary file and delete in VBA for Excel coding
Replies
2
Views
493
jolor69
J

Forum statistics

Threads
1,214,649
Messages
6,120,733
Members
448,987
Latest member
marion_davis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top