如果在同一文件夹
Private Sub CommandButton1_Click()
Dim aa As String
aa = TextBox1.Text & TextBox2.Text & TextBox3.Text & TextBox4.Text & TextBox5.Text
Open ThisWorkbook.Path & "\db上传.txt" For Append As #1 'Output 是覆盖
Print #1, aa
Close #1
Unload Me
UserForm1.Show
End Sub
如果在同一文件夹
Private Sub CommandButton1_Click()
Dim aa As String
aa = TextBox1.Text & TextBox2.Text & TextBox3.Text & TextBox4.Text & TextBox5.Text
Open ThisWorkbook.Path & "\db上传.txt" For Append As #1 'Output 是覆盖
Print #1, aa
Close #1
Unload Me
UserForm1.Show
End Sub