Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 26th, 2005, 04:44 AM
Registered User
Join Date: Aug 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Not able to run my application twice!

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
COM Exception while run the C# Application saravanan.k General .NET 0 March 19th, 2007 09:07 AM
run application more than once!!!! angelboy C# 2005 2 February 12th, 2007 03:53 PM
run application without .NetFramework !!!!! angelboy C# 2005 2 January 17th, 2007 04:24 PM
How to run servlet under application? kuterka Servlets 1 February 11th, 2005 08:21 AM
automatic run of an application deb_prgmr Visual Basic 2005 Basics 0 December 20th, 2004 09:37 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.