Runtime Error '53' File Not Found

[mathewjenkinson]

hi all,
I wrote a program in Excel that calls a form to load when an action happens on a spreadsheet page, the code I used to call the form from is

sqe_portal.UserForm_Initialize 

however since upgrading to MSoffice 2003 i get the runtime error '53' file not found. the files still their...? any ideas?

Thanks.
Mathew.

[norie]

Mathew

Why are you calling the userform's Initialize event?

Why not just use Show?

[royUK]

Can you post the full initialise code?

[mathewjenkinson]

Private Sub Workbook_Open() 
    sqe_portal.UserForm_Initialize 
End Sub 

will try it with show now.
1 sec.

[mathewjenkinson]

nope.

the show command brings up the same error.

the code is in place to bring up the user form 'sql_portal' when the workbook is opened.

is their another way I can get the form to load on startup?
Mathew.

[norie]

mathew

As Roy has requested can you post the code?

[mathewjenkinson]

mathew

As Roy has requested can you post the code?

see post above,

did you want the code to the following form? its a bit long...

[norie]

Mathew

The code we need to see is the code for the Initialize event.

That could be where the error is actually happening.

[mathewjenkinson]

Private Sub Workbook_Open() 
    sqe_portal.UserForm_Initialize 
End Sub 

will try it with show now.
1 sec.

isnt that the code for the initalize event? I'm confused..?

[norie]

No it's not.

That code calls the Initialize event, which is actually something I wouldn't recommend doing.