Runtime Error 424

[DNA]

When the spreadsheet in local, on my HD, all is well. When I put the
spreadsheet on the server, I get this error.

Any ideas? It's driving me nuts. The ironic thing ... it use to work
just fine.

Thanks for your help!!

 

[rohandawate]

Hi,

Check for the properties or methods assigned to the file system object
if you are using. For eg: you may be referencing the spreadsheet on
your local machine with a caertain path which may not be valid on the
server side. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamsgnotobject.asp
for more information.

Cheers,
Rohan