怎样把VB数组数据写入".txt"文件或Eexcel文件?例如我定义了两个数组,一个用来存放x点坐标,一个存放y点坐标.现在要在记事本或在excel里按照X,Y这种格式写出来，怎么做呢?
热心网友
必需存在保存文本的路径,用以下代码能实现按照X,Y这种格式储存在文本文件.可用EXCEL打开该文本文件方式查看.Option ExplicitDim i As IntegerDim a As IntegerDim x(100) As SingleDim y(100) As SinglePrivate Sub Command1_Click() a = 10 Open "c:\wenben\xy.txt" For Output As #1 For i = 0 To a Print #1, x(i) & "," & y(i) Next i CloseEnd Sub