Skip to content

Instantly share code, notes, and snippets.

@pwm1991

pwm1991/export-csv

Created October 28, 2019 12:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save pwm1991/ec7f23798d0b1c8e2efe4116817f4267 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save pwm1991/ec7f23798d0b1c8e2efe4116817f4267 to your computer and use it in GitHub Desktop.
Download ZIP
Export CSV macro, lazily.
Raw
export-csv
Sub ExportCSV()
'
' ExportCSV Macro
'
'
Range("A1").Select
ChDir "\\rsnet.local\Users\UserData$\peterm\Downloads"
ActiveWorkbook.SaveAs Filename:= _
"\\rsnet.local\Users\UserData$\peterm\Downloads\export.csv" _
, FileFormat:=xlCSV, CreateBackup:=False
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment