General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Execute code for an Excel spreadsheet
I need to execute instructions such as:
Dim dbs As database
Dim strSQL As String
Dim fld As Field
Dim rs1 As Recordset
On Error Resume Next
Set dbs = CurrentDb()
fld.Attributes = dbAutoIncrField
With tdf
.Fields.Append.CreateField("PersonID,dbLong")
End With
strSQL = "SELECT PersonID FROM .. ORDER ... "
DoCmd.RunSQL (strSQL)
The coding cannot be performed with a macro related to Excel.
Thank you.