I have opened an excel file via VBA Access and can read and write in the Excell Cells. How can I tick an Excell Ckeck Box?
the code is :
Dim Excel_App As Object
Dim strExcel As String
Set Excel_App = CreateObject("Excel.Application")
Excel_App.Visible = True
Excel_App.Workbooks.Open (fready)
With Excel_App
.CheckBox3.Value = True 'This line is used in VBA Exell and I need in Access
End With
Aucun commentaire:
Enregistrer un commentaire