Error while open excel in another computer

[mmf]

HI
I have a excel file with vba code that works fine when I open it from Excel in my computer, but then I made a link to a portal where other people access the file trough a web link using excel. The excel sheet opens ok, and I can see is like having a desktop excel but then some of the code that I wrote its get some errors that I do not why they are happening.
I tryed the help
then for the first error its say that I have to declare properly the vairable,
I tryed as variant and then as date but with non of those option I got any improvement
from the other side the second error I checked that the path is correct.

Excel version are the same 2003 and not missing reference are highlighted
any hints why this is happenign I will really appreaciate
Best Regards

the errors are as follow:
Error 1:
run time error 13
Type mistmatch
this is part of the code the error is highlighted wehre the confused face is

Please Login or Register  to view this content.

The other error is as follow and happen when another excel file is opened using a btn.
run time error 1004
Method 'Open' of object 'Workbooks' Failed

Please Login or Register  to view this content.

[royUK]

Maybe as you are using CLng you should declare your variables as Long.

Is the path correct in your second problem?

[mmf]

Hi Roy
I tried to declare the variable as long but still getting the error.
I double checked the path as is the right one but still getting the Method fail error
It is to envisage that I only get the errors when I am opening the file from the web link and not when I am using Excel from the desktop.
So I do not know if something related with the web link compatibility but when I checked the version from the web is the same as the desktop
I really appreciate any other suggestion to assess why this error are happening?
Regards
MMF