|
Major Member
|
引用:
|
作者untitled
vba可行,我幹過
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
cn.Open "provider=microsoft.jet.oledb.4.0;" & _
"data source=" & SourceFile & ";" & _
"extended properties=excel 8.0; "
rs.Open "select * from [Sheet Name$A:F]", cn
|
請問這些是Excel的vba巨集嗎?對巨集實在是不太懂,我只會寫一些爛爛的Excel函數而已,冏!!
__________________
|