View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
faustino Dina faustino Dina is offline
external usenet poster
 
Posts: 10
Default My workbook doesn't works on no other PC exept mine....

Keith,
I created some VBA functions and packed them inside the FortiaExcel.xla file
that is registered in my PC in the path:
C:\Documents and Settings\fdina.MATUSA.000\Application
Data\Microsoft\AddIns\FortiaExcel.xla
In the Test.xls document, in the cell C4 I call the function
=fcGetExiAct(A4,B4). It works great.
Then on a second PC I first register the FortiaExcel.xla. This PC is Windows
98 then the FortiaExcel.xla goes into the path
C:\Windows\Application Data\Microsoft\Complementos\FortiaExcel.xla (spanish
version)
When I open the Test.xls document, it reports some links are broken. I don't
restore the links. When I inspect the definition for the cell C4 the content
is the following:
='C:\Documents and Settings\fdina.MATUSA.000\Application
Data\Microsoft\AddIns\FortiaExcel.xla'!fcGetExiAct (A4,B4)
i.e. it remembered the full path that has the FortiaExcel.xla on my PC! It
is no wise enought to consider the path of the FortiaExcel.xla that I
registered in this PC. I'm missing something. But what?

Thanks
Faustino