ILOGIC - EXCEL

[Anonymous]

Hi all

I have a spreadsheet that I have ilogic writing data too and is working well. However, I'd like to adapt the code a little.

Previously, I had ilogic check a column in an excel spreadsheet for the document number of my open inventor drawing. If it found a matching cell it then wrote data to various cells in the excel row.

I'd like now that ilogic searches - as before - for the document number and If it finds the document number AND cell C is empty then it writes some data.

can anyone shine some light on this please? )

SyntaxEditor Code Snippet

'Search for the file name in column A
For oRow = RowStart To RowEnd

If (GoExcel.CellValue("A" & oRow)) = oDocNumber & (GoExcel.CellValue("C" & oRow) = "") Then
    GoExcel.CellValue("G" & oRow) = "TEST WORKED"

[MechMachineMan]

Have you tried using the code you wrote with the appropriate "End if" and "Next" statements?