I created a test xla file and wrote a simple function and subroutine which I call from another excel file. According to a book I have there are two ways I can call a subroutine:
1. Application.Run "filename.xla!subname"
This method works.
Another way is to just call the subroutine using it's subname. However, this requires setting a reference to the xla file.
So, I set a reference to the file (prior to this I made sure that the xla file was not checked off in the list of add in files). However, I got the following message:
"Name conflicts with existing module, projet, or object library."
I read one post saying that the names of the various objects needed to be different so I changed the names of the sheets and modules in the xla file; it's a simple file so this just meant chaning sheet1 to s1, etc.
Any ideas? btw, using 03 in xp.
Thanks!
1. Application.Run "filename.xla!subname"
This method works.
Another way is to just call the subroutine using it's subname. However, this requires setting a reference to the xla file.
So, I set a reference to the file (prior to this I made sure that the xla file was not checked off in the list of add in files). However, I got the following message:
"Name conflicts with existing module, projet, or object library."
I read one post saying that the names of the various objects needed to be different so I changed the names of the sheets and modules in the xla file; it's a simple file so this just meant chaning sheet1 to s1, etc.
Any ideas? btw, using 03 in xp.
Thanks!
