FileN = C:\ほげほげ\エクセル.xlsm SNo = シートNo ※これが、 Function MyADOExcel666(FileN As String, SNo As Long) Dim cn As Object Dim rs As Object Dim adoCat As Object Set cn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset") cn.Provider = "Microsoft.ACE.OLEDB.12.0" cn.Properties("Extended Properties") = "Excel 12.0;HDR=NO;IMEX=1" cn.Open FileN Set adoCat = New ADOX.Catalog Set adoCat.ActiveConnection = cn MyADOExcel666 = adoCat.Tables(SNo).Name ' rs.Close ' Set rs = Nothing ' cn.Close ' Set cn = Nothing End Function