Option Compare Database Option Explicit Sub SharePointList_Link() Dim tdf As TableDef Set tdf = CurrentDb.CreateTableDef("ListXX") tdf.Connect = "ACEWSS;HDR=NO;IMEX=2;" & _ "ACCDB=YES;" & _ "DATABASE=http://SharePointSiteURL;" & _ "LIST=ListName or ListGUID;" & _ "VIEW=ViewGUID;" & _ "RetrieveIds=Yes" 'IMEX=1 ReadOnly tdf.SourceTableName = "ListName" CurrentDb.TableDefs.Append tdf Application.RefreshDatabaseWindow End Sub
0 件のコメント:
コメントを投稿