Hello!
I have some troubles with excel VBA,could someone please help??
My problem goes like this:
The user enters some data on a spreadsheet; after clicking on a command button, the data are passed to an .inp file (ECDISP.INP) and a dll is called (the .inp file is dll's input). The dll's output is an .out file, which is passed to a second sheet in the same workbook as the result of the whole process.
Now, I want the user to be able to go to the first sheet again, make the changes he wants to the input and get the new results in the second sheet, after clicking on the same button.
But I get an error message saying:
"Run-time error '1004':
Cannot access read-only document 'ECDISP.INP'."
So I have to close the .xls file and re-open it every time I want to change the data!!!!Can I somehow avoid it??
Any ideas?
Thanks a lot in advance!!