runtime error 75 when I run the application for second time
 

Hello.

I have a worksheet in which I have a button which call the foll macro
Private Sub cmdCases_Click()
Load frmCases
frmCases.Show vbModal
End Sub

When I open the worksheet for the first time, everything
works fine. However, when I exit the above code, and
then reopen the worksheet, I get the following VB errors:


"Path/File Access Error", and
"Run-Time Error 75, Cannot find the specified object"


When I hit the DEBUG button, the "Load frmcases" is
highlighted (see code, above).

can anybody help


Thanks!

runtime error 75 when I run the application for second time
 

You should unload frmCases to load it again.
May be, you only hide it, but not unload?


"divya" wrote:

Hello.

I have a worksheet in which I have a button which call the foll macro
Private Sub cmdCases_Click()
Load frmCases
frmCases.Show vbModal
End Sub

When I open the worksheet for the first time, everything
works fine. However, when I exit the above code, and
then reopen the worksheet, I get the following VB errors:


"Path/File Access Error", and
"Run-Time Error 75, Cannot find the specified object"


When I hit the DEBUG button, the "Load frmcases" is
highlighted (see code, above).

can anybody help


Thanks!

runtime error 75 when I run the application for second time
 

hii,
This is the application which worked fines since so many years and
was used extensively by every body here .Now a days it gives this eroor
sometimes Runtime 75 and sometimes 1004, few Machines it works fine and
few machines it doesn't.it shows different behaviour on different
machines gives different error on different machinesi"m working on it
with what u said <but i don"t want to meddle with the code , thnx for
ure help.will let u know .

Regards
Divya
Irina wrote:
You should unload frmCases to load it again.
May be, you only hide it, but not unload?


"divya" wrote:

Hello.

I have a worksheet in which I have a button which call the foll macro
Private Sub cmdCases_Click()
Load frmCases
frmCases.Show vbModal
End Sub

When I open the worksheet for the first time, everything
works fine. However, when I exit the above code, and
then reopen the worksheet, I get the following VB errors:


"Path/File Access Error", and
"Run-Time Error 75, Cannot find the specified object"


When I hit the DEBUG button, the "Load frmcases" is
highlighted (see code, above).

can anybody help


Thanks!
Hii