Hi all - this has been driving me nuts all night as I can't think how to remedy it.
Essentially I am taking a list
of file names from one sheet and, with a macro, having it save the contents of various cells in a .txt file (masked as an
.sfv file for file checksum checking).
The problem I am having though, is any filenames (values) that have a comma
in them, come out in the .sfv file with quotation marks either side of them. This is not ideal - I was hoping somebody would
be able to help me!
This is how my macro is looking at the moment:
Dim strDate As String
strDate = Format((Date), "yyyy-mm-dd")
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=True, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:="C:filename_(" & strDate & ").sfv", FileFormat:=xlText,
Here is an example of what the contents of the .sfv file comes out like:
I hope somebody can help me! Any help would be appreciated. Cheers.