I'm facing an issue with my JavaScript code. Here's what I have:
a = Excel.Workbooks.open("C:/work/ind12.xls").ActiveSheet.Cells.find("value");
if(a == null)
document.getElementById('dateValid').innerText = "Date not Valid";
Excel.close();
The code is connecting to my Excel sheet and finding a specific value, which works perfectly fine. However, after it's done, the page refreshes and all the values in text boxes and other elements are lost. Is there any way to prevent the page from refreshing or retain my values?
Thank you.