Skip to content

Instantly share code, notes, and snippets.

View paullinney's full-sized avatar

Paul Linney paullinney

View GitHub Profile
@paullinney
paullinney / gist:fb638dbb84149cbe0a0e
Created December 15, 2015 12:19 — forked from fabriceleal/gist:7803969
Decent enough macro for exporting csvs from Excel.
' http://support.microsoft.com/kb/291296/en-us
' http://superuser.com/questions/130592/how-do-you-force-excel-to-quote-all-columns-of-a-csv-file
' - change integer to long indexing
' http://stackoverflow.com/questions/2524703/save-text-file-utf-8-encoded-with-vba
' - output utf8 content
Sub QuoteCommaExport()
' Dimension all variables.
Dim DestFile As String
Dim FileNum As Integer