Hi,

My application uses PI in some cases we export the file to an excel sheet. My problem is when i install new version of PI SDK 3.1.1.0 withPI Datalink i found that when i export the file it doesn't export file successfully. So far i figure out that when using old Version of PI 3.0 and when i export the file it will open one little Microsoft Forms window and it states that " This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this file, select ok and the controls will be initialized using your current workapsce settings" and i should have to click OK twice to export the file successfully onto Excel. What i understand is it is trying to connect to Add-on's using PIData link and with the help of ADD-ons it can export the successfully but this happens with old version of PI (3.0) but when i install new version of PI (3.1.1.0) when i click export on my application it doesn't open that Microsft Foms window and also my application shows that it finish exporting till 20% but after that it stops exporting. So my question is why i am getting this trouble. Is this related to PIDatalink which has been problem with Add-ons.


Any help much appreciated.

Thanks,
Laxmi

RJK Solutions, RapidPI.

Hi,

Thanks for the reply.....

Basically i installed PIDATALINK 1.3.6 on my machine and start exporting my application it exports to some extent and stops. When i debug my code i figure out that my code is trying to Load PI ADD-ins for PIPC32.xll file and i found out that it can easily add to the older version of PIDATALINK but when i install new version it didnt work and stops exporting until at a point where it tries to Load Addins. Overall i can say that new version of PIDATA Link has some problem with ADd-ins. But i can give a try where you mention that to check the Excel Security Settings but in mean time if you are familiar with this Add-ons for PIPC32.xll let me know how to work out.


Cheers,
Laxmi

Hi,

I have Office 2003 installed on my machine.


The code is written in Oracle forms bit difficult to debug, but some how i managed to debug and found that with new version of PI DATAlink when i installed on my PIHOME directory (C:\Program Files\PIPC\Excel) it is looking at the Excel files and also Add-ins but couldn't Load PI add-ons and stops exporting the file. I assume when i install PI DataLink_3_1_3.exe (Old version) and after i install and open Excel and go to Tools -> Add-Ins and choose PIDataLink and click OK it opens a Microsoft Forms little window and the message shows that "This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this file, select OK and the controls will be initialized using your current workspace settings." But when i install New version PIDataLink_4_0_3_.exe and when i open Excel and Go to Tools - >Add-Ins and choose PIDataLink and click ok this Microsoft Form messag box doesn't appear. This has nothing to do with my code you can try if you want to debug.

Regads,
Laxmi