LsAgXLB vision XL error on source data model

Skagga

New Member
Joined
Aug 2, 2017
Messages
1
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:p></o:p>
<o:p></o:p>
We have recently done a Sun upgrade which has caused me somany frustrations. <o:p></o:p>
<o:p></o:p>
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:p></o:p>
<o:p></o:p>
Can it be that I lose this reference from computer tocomputer because some PC’s do have Sun and other don’t.<o:p></o:p>
<o:p></o:p>
Would it be of any help if I add the XLB reference to eachof the models.<o:p></o:p>
<o:p></o:p>
If Not Referenced Then<o:p></o:p>
.AddFromFile "C:\Program Files\Infor\Query andAnalysis\LsAgXLB.xla"<o:p></o:p>
End If<o:p></o:p>
<o:p></o:p>
Or would I only have this reference on my C drive if Sun isinstalled on my machine?<o:p></o:p>
<o:p></o:p>
Any help would be greatly appreciated.<o:p></o:p>
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,275
Messages
6,171,127
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top