同意3楼的说法,具体是这样实现的. 最简单的方法是将每行的文本数据用","分割,如: 张三,21,速度 李四,20,达到 再将文件后缀改为csv,这样默认的是用excel打开Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As LongPrivate Sub Command1_Click() Dim s As String s = "d:\aaa.csv" Call ShellExecute(hwnd, "Open", s, "", App.Path, 1) End Sub
Excel 工作表有无表头?占了几行?你究竟要 VB 代码,还是 VBA 代码?
最简单的方法是将每行的文本数据用","分割,如:
张三,21,速度
李四,20,达到
再将文件后缀改为csv,这样默认的是用excel打开Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As LongPrivate Sub Command1_Click()
Dim s As String
s = "d:\aaa.csv"
Call ShellExecute(hwnd, "Open", s, "", App.Path, 1)
End Sub