My workbook doesn't works on no other PC exept mine....
"faustino Dina" wrote in message
...
I created a function in a .xla file. I call this function from a cell in
.xls without any problem.
Then I go to another machine. I register the .xla on this machine. Then
when
I load the .xls file created on the first PC, Excel says that the links
are
incorrect. Because of that I cant' deploy the solution through my
organization 'cause it is almost impossible go PC by PC reconfiguring the
links... What can I do?
You cant succesfully register an xla file, the workbook remembers
where the xla file waslocated and looks in the last place
it loaded it from, if you move the file to another directory
or drive it wont find it
To set the reference go into the VBA editor, select ToolsReferences
and browse for the .xla file, its also possible to set the
reference programmtically
Keith
|