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 comman
button, the data are passed to an .inp file (ECDISP.INP) and a dll i
called (the .inp file is dll's input). The dll's output is an .ou
file, which is passed to a second sheet in the same workbook as th
result of the whole process.
Now, I want the user to be able to go to the first sheet again, mak
the changes he wants to the input and get the new results in the secon
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 t
change the data!!!!Can I somehow avoid it??
Any ideas?
Thanks a lot in advance!

--
nicky0
-----------------------------------------------------------------------
nicky05's Profile: http://www.excelforum.com/member.php...fo&userid=2666
View this thread: http://www.excelforum.com/showthread.php?threadid=39940