I have couple of templates (each template have 8 input forms), which use some
common data and functionality. Templates are accessed through intranet. I
have put the common data and functionality in another template and saved it
as xla.

How it works : From the intranet someone can open & run a template . If a
particular option is clicked the common data "xla" opens and data is
accessible. It works fine until i run the main template from my PC. When i
try to run it from the intranet it gives me following error.

Run-time error '1004'
Method 'Open' of object 'Workbooks' failed

I use the below code to open the xla file
Workbooks.Open ("http://-------/abc.xla") 'complete url

Anybody having any idea what could be the possible reason and solution for
this


--
Ajit