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

If you open the inp file, do you close it after writing to it?

Does the .dll file also close it when done?

It sounds like one of your applications has kept it open for exclusive
access.

--
Regards,
Tom Ogilvy

"nicky05" wrote in
message ...

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!!


--
nicky05
------------------------------------------------------------------------
nicky05's Profile:
http://www.excelforum.com/member.php...o&userid=26664
View this thread: http://www.excelforum.com/showthread...hreadid=399400

You are right!
I made several tests and finally the problem seems to be the dll .
Thanks for your reply!! :)


--
nicky05
------------------------------------------------------------------------
nicky05's Profile: http://www.excelforum.com/member.php...o&userid=26664
View this thread: http://www.excelforum.com/showthread...hreadid=399400