I have a workbook model which separate teams all over theworld have restricted access to. I use this model to extract info from our GLwith Vision XL. Only the offices in London have Sun accounting softwareinstalled on the PC’s. <o></o>
<o></o>
We have recently done a Sun upgrade which has caused me somany frustrations. <o></o>
<o></o>
I own the models and I have Sun on my PC, I then send theworkbooks to a list of different people all over the world, they are supposedto update the workbook and run a few macros to perform checks on integrity oftheir changes, since the sun upgrade, they get a “Cant find Project or Libraryerror”. I have informed them how to sort this out but when they send it back toour accounting team with SUN they again have a similar issue, but if I send itdirectly to our accounting team they don’t have the issue.<o></o>
<o></o>
Can it be that I lose this reference from computer tocomputer because some PC’s do have Sun and other don’t.<o></o>
<o></o>
Would it be of any help if I add the XLB reference to eachof the models.<o></o>
<o></o>
If Not Referenced Then<o></o>
.AddFromFile "C:\Program Files\Infor\Query andAnalysis\LsAgXLB.xla"<o></o>
End If<o></o>
<o></o>
Or would I only have this reference on my C drive if Sun isinstalled on my machine?<o></o>
<o></o>
Any help would be greatly appreciated.<o></o>
<o></o>
We have recently done a Sun upgrade which has caused me somany frustrations. <o></o>
<o></o>
I own the models and I have Sun on my PC, I then send theworkbooks to a list of different people all over the world, they are supposedto update the workbook and run a few macros to perform checks on integrity oftheir changes, since the sun upgrade, they get a “Cant find Project or Libraryerror”. I have informed them how to sort this out but when they send it back toour accounting team with SUN they again have a similar issue, but if I send itdirectly to our accounting team they don’t have the issue.<o></o>
<o></o>
Can it be that I lose this reference from computer tocomputer because some PC’s do have Sun and other don’t.<o></o>
<o></o>
Would it be of any help if I add the XLB reference to eachof the models.<o></o>
<o></o>
If Not Referenced Then<o></o>
.AddFromFile "C:\Program Files\Infor\Query andAnalysis\LsAgXLB.xla"<o></o>
End If<o></o>
<o></o>
Or would I only have this reference on my C drive if Sun isinstalled on my machine?<o></o>
<o></o>
Any help would be greatly appreciated.<o></o>