I have a VBScript that opens an Excel File called Test.xlsx and adds a checkbox. It places this checkbox in cell A1. I'm trying to find out how I can add this check box to another cell instead (for example, go to cell X61 and insert the checkbox there), here's my VBScript
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.DisplayAlerts = True
Set objWorkbook = objExcel.Workbooks.Open("C:\Users\Test\Desktop\Test.xlsx")
Set objWorksheet = objWorkbook.Worksheets(1)
Dim chkBox
Set chkBox = objWorksheet.CheckBoxes.Add(0,0,0,0)
chkBox.Caption = ""
Set objWorkbook = Nothing
Set objWorksheet = Nothing
Set objExcel = Nothing
Thank you
Aucun commentaire:
Enregistrer un commentaire