Want to save a CSV that has formula-generated blanks

[lisaspencer]

I use CSVs to upload data online (such as contacts) and they have specific fields. I'm trying to make the form process as easy as possible for someone to do who is a computerphobe, and I found someone's VBA code that I can assign to a button that can basically turn all formulas into values without having to do any copy+pasting or keyboard shortcuts (as I say, because they're a computerphobe and the easiest way to do this is to give them buttons to click on).

This is the VBA code.

Sub Formulas_into_Values()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
    Cells.Copy
    Cells.PasteSpecial Paste:=xlPasteValues
Next ws
End Sub

The problem I'm having now is that where there are formulas on that page initially that the macro will turn into values, I guess they're not true blanks, and when it's saved as a CSV file, and you upload the CSV, it produces loads of null values where there should be empty cells (so the empty ones shouldn't show up at all).

Can anyone help?

 

[Joe4]

Can you provide us with two things:

1. Post the underlying formula that is being converted to values that is causing issues.

2. View your resulting CSV file in a Text Editor (like NotePad), and copy paste one line that has a problematic value, and show us with value in the line it is.