01-14-2020
05:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
01-14-2020
05:26 PM
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 SubAfter "GoExcel.Open" you can reference the cells on that sheet directly.