How to create text file using VBA for Excel for MacOS

Question

I am trying to create a file and save text into it. I tried below code but when I am using write #1, script will just replace existing text with the new text. I tried write #0 but no luck. Any suggestions.

Sub TestResultFile(output As String)
  Dim myFile As String
  myFile = Application.DefaultFilePath & "TestResults.txt"
  Debug.Print myFile
  Open myFile For Output As #1
  Write #1, output
  Close #1
End Sub

Update:

Answer by Lakshmi helped me solve this issue.

If you look it up in The Programmers Guide to Visual Basic it says Visual Basic allows you to process drives, folders, and files in two different ways: through traditional methods such as the Open statement, Write#, and so forth, and through a new set of tools, the File System Object (FSO) object model. — Noodles
– Noodles, Commented Mar 12, 2019 at 6:17
@Noodles I am not able to use File System Object (FSO) because FSO if for Excel for Windows. Can you please confirm? — meMadhav
– meMadhav, Commented Mar 12, 2019 at 6:26
@meMadhav I mean try to use different file open mode. Instead of For Output use For Append. Then write your output string to the file and it should not replace existing text — xmojmr
– xmojmr, Commented Mar 12, 2019 at 7:43

Lakshmi Yadav · Accepted Answer · 2020-05-06 10:53:15Z

6

User Append to add text to new line.

try below code-

Sub TestResultFile(output As String)
  Dim myFile As String
  myFile = Application.DefaultFilePath & "TestResults.txt"
  Debug.Print myFile
  Open myFile For Append As #1
  Write #1, output
  Close #1
End Sub

answered May 6, 2020 at 10:53

Lakshmi Yadav

1661 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create text file using VBA for Excel for MacOS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related