看下面的代码,如何将label1的文字保存在的*.csv的文件里的字符为红色?
If Dir("c:\备份", vbDirectory) = "" Then MkDir "c:\备份"
Open "c:\备份\" & Format(Date, "yyyymmdd") & ".csv" For Append As #1 '用append的方式打开,如果已存在就追加在尾部
Print #1, Text1.Text & "," & Cmb1.Text; "," & Label.Caption & ",";
Close #1
If Dir("c:\备份", vbDirectory) = "" Then MkDir "c:\备份"
Open "c:\备份\" & Format(Date, "yyyymmdd") & ".csv" For Append As #1 '用append的方式打开,如果已存在就追加在尾部
Print #1, Text1.Text & "," & Cmb1.Text; "," & Label.Caption & ",";
Close #1
Private Sub Command1_Click()
Dim xlApp As Object 'Excel.Application
Dim xlWb As Object 'Excel.Workbook
Dim xlWs As Object 'Excel.Worksheet
Dim sFileName As String
Set xlApp = CreateObject("Excel.Application")
Set xlWb = xlApp.Workbooks.Add()
Set xlWs = xlWb.Worksheets(1)
With xlWs.Cells(1, 1)
.Value = Label1
.Font.ColorIndex = 3
End With
If Dir("c:\备份", vbDirectory) = "" Then MkDir "c:\备份"
sFileName = "c:\备份\" & Format(Date, "yyyymmdd") & ".xls"
If Dir(sFileName) <> vbNullString Then Kill sFileName
xlWb.SaveAs sFileName
Set xlWs = Nothing
xlWb.Close
Set xlWb = Nothing
Set xlApp = Nothing
End Sub