vendredi 1 septembre 2017

How can I tick an Excell checkbox from VBA Access

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