Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
J-Camper
in reply to: Anonymous

Try something like this:

Sub Main

Dim xlsxPath As String
xlsxPath = "C:\Users\tm04.smeric\Desktop\Meric\EXCEL NOZZLE LIST.xlsm"

GoExcel.Open(xlsxPath, "Sheet1")

GoExcel.CellValue("A4") = "Link NOZZLE iProp name"
GoExcel.CellValue("B4") = "Enter P value"
GoExcel.CellValue("C4") = "Enter VC value"
GoExcel.CellValue("D4") = "Enter VL value"
GoExcel.CellValue("E4") = "Enter MC value"
GoExcel.CellValue("F4") = "Enter ML value"
GoExcel.CellValue("G4") = "Enter MR value"

'GoExcel.DisplayAlerts = False
GoExcel.Save
'GoExcel.Application.visible = True
GoExcel.Close

End Sub

After "GoExcel.Open" you can reference the cells on that sheet directly.