Solved Export a String as CSV (1 Viewer)

[XelaIrodavlas]

Hi all,

I recently asked how to Import CSV data (in the form of a string) into an Access Recordset. But now I need to do the reverse.

I'm running an API request which returns a CSV string, and would like to save that to somewhere on the user's PC. I currently have no idea how to do this. I've tried the TransferText method, but that only works with existing Queries/Tables. Any ideas?

Thanks
Alex

 

[CJ_London]

one idea is to google your question - you would come up with links like this

How to create and write to a txt file using VBA

I have a file which is manually added or modified based on the inputs. Since most of the contents are repetitive in that file, only the hex values are changing, I want to make it a tool generated f...

stackoverflow.com

 

[ebs17]

Public Sub Append2TextFile(ByVal Content As String, Optional ByVal TextFile As Variant)
    Dim FF As Long
    If IsMissing(TextFile) Then TextFile = CurrentProject.Path & "\Log.txt"
    FF = FreeFile()
    Open TextFile For Append As FF
    Print #FF, Content
    Close #FF
End Sub

'-----------------------------------------------

Append2TextFile sCSVstring, "X:\Anywhere\MyFile.csv"

 

[XelaIrodavlas]

Public Sub Append2TextFile(ByVal Content As String, Optional ByVal TextFile As Variant)
    Dim FF As Long
    If IsMissing(TextFile) Then TextFile = CurrentProject.Path & "\Log.txt"
    FF = FreeFile()
    Open TextFile For Append As FF
    Print #FF, Content
    Close #FF
End Sub

'-----------------------------------------------

Append2TextFile sCSVstring, "X:\Anywhere\MyFile.csv"

This works perfectly

Thanks ebs17, I hadn't considered the similarity between .text and .csv