lhardee
02-26-2008, 07:35 PM
Hello to all :hi:
Great forum. I am somewhat new to vb and would like to post a question. After searching high and low, I have been unsuccessful in finding out the best way to use multiple instances of excel. I would like to use a vba form at the same time seperate excel applications are running.
application.remoterequests = false seems to be the best option. My only concern is if/when there might be a fatal error and remoterequests hasn't been set back to true.
Is there some way to trap errors and switch remoterequests back to true if fatal error should occur ?
Thank you for your time.
Great forum. I am somewhat new to vb and would like to post a question. After searching high and low, I have been unsuccessful in finding out the best way to use multiple instances of excel. I would like to use a vba form at the same time seperate excel applications are running.
application.remoterequests = false seems to be the best option. My only concern is if/when there might be a fatal error and remoterequests hasn't been set back to true.
Is there some way to trap errors and switch remoterequests back to true if fatal error should occur ?
Thank you for your time.