Export Table as CSV UTF-8

[hcabs99]

Hi

Can anyone help me with the code i would need to extract a table to the users desktop as a csv utf-8, but also with No headers please?

Cheers

 

[Micron]

Don't need code. On ribbon, External Data, Export tab select text> choose location and option(s), click next, specify character encoding on next dialog.

 

[hcabs99]

Thanks, was not aware of this, but any idea how i can do it so i exclude the header please?

 

[Micron]

Did you try it and got headers or are you just assuming you'll get them?

 

[hcabs99]

I got headers in the extract as expected, but i wanted to exclude them. I figured it out finally (well google did!)

Dim XL As Object
Set XL = CreateObject("Excel.Application")
With XL
.Visible = False
.displayalerts = False
.Workbooks.Open "C:\Users\Public\Documents\Autostore_File.csv"
.Rows("1:1").Delete
.ActiveWorkbook.Close (True)
.Quit
End With
Set XL = Nothing

Thankyou for your help and advise .

 

[Micron]

I got the same thing (no headers) using the exporter and choosing no options in the initial dialog and then not choosing "Include field names on first row" in the subsequent dialog - no code. Not sure how much I helped because of the difference in approaches.