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

Let me try to make it simple

I have an excel spreadsheet that uses a macro to open
another excel spreadsheet via Workbooks.Open(filename)


On my local drive this works fine and it opens the second
file, runs the query, and closes it without complaint.
When I run it via a network drive it works fine as well.


However, when I try to run it via a browser (i.e. put the
file on a web server and then open the url as
http://www.whatever.com/myfile.xls") and then run the
macro I get a runtime error 1004 stating "Method 'Open' of
object 'Workbooks' failed".

Any idea what is causing this?




"Ajit" wrote:

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