cafshari

But does it actually save? Because god forbid the sheet actually is modified, I don't want to save those changes. Sorry, I'm not following!!

But I don't want to touch anything in the excel file. In the case that something is being modified, I don't want to save it. That Excel file can't be touched.

Nothing is being changed in the workbook, as far as I know. I have it being opened as hidden and read-only.

No, I just copy 5 cells from it. Not sure if that counts as modifying

water, thanks for your help so far. I have that working. Now my script is called to run 5 times, and in each of those times it opens an excel workbook. I want the book to close after each run. It is closing, however I am seeing the Save/Don't Save/Cancel prompt pop up each time. I do not want it to save, I just want it to close. How do I get this to not show up? I have my workbooks opening as hidden, btw. $iRow = $iRow + 1 If _ExcelReadCell($oExcel, $iRow, 4) = "" Then ; if the next cell is empty, reset the variable to 36 and end script IniWrite($inifileloc, "Main", "Row", 36) _ExcelBookClose($oExcel, 0, 0) Exit EndIf $oExcel.Quit IniWrite($inifileloc, "Main", "Row", $iRow) Am I using _ExcelBookClose incorrectly? I thought the 2nd '0' parameter is to disable the message alert? Thanks in advance.

Sorry, but what exactly would my INI file look like? I'd rather not make assumptions, since I have no experience with this. Some research leads me to believe its just: [Main] Row=36 Oh, and will that .ini file save on its own?

No, I want it to start at row 36, and perform 5 times. then start at 36 again. Btw why can I only make 8 more posts?

I am a complete commandline newb. I'd prefer not to use it if I don't have to, as i have no idea what i'm doing. regarding the first part of what you said, I don't have access to the row in Java. Are you suggesting I read the excel row in my java code?

My script reads an excel cell and uses the value of it. After I run the script the first time, in the next run, I want to read the row+1 (the value of the cell beneath the previous one). I've thought of just doing $row = 36, and then at the end of my code, increment it... but that wouldn't work. Any ideas? I would also need to reset that variable's value back to 36 after it hits 40. This script is being executed from a Java function in Eclipse. I also thought maybe I could pass a variable/value to the script from where I call the script in my Java code, but I'm not sure if that's possible? I've thought of making 5 different scripts, 1 for each cell location, but my Java function locates only 1 script and executes it. A For loop wouldn't work in my script, because my task has to end the script and perform some other work before I need to run the script again. I hope this is understandable, as this is hard for me to explain. ... Local $ImageLoc = _ExcelReadCell($oExcel, 36, 4) ; need row# to increment after each time the script is run. Send($ImageLoc) Send("{ENTER}")