Step 7 Libnodave & excel

moelsayed

Level-1
Beiträge
6
Reaktionspunkte
0
Zuviel Werbung?
-> Hier kostenlos registrieren
Hi All,

I am looking for any document to explain libnodave library and how can i integrate it inside excel to get some reading from siemens microbox over TCP/IP.

Thanks In Advance.

Moelsayed
 
Zuviel Werbung?
-> Hier kostenlos registrieren
[QUOTE = PN / DP; 619496] Hi, in Libnodave package are included html files with explanation of the mostimportant functions (I think a folder with name "doc") Here in wants to find a working Excel example. In the Excel file open the VBA module, you will find declarations and short descriptions of the used functions from the Library. Harald [/ QUOTE]





Thank you very much
Moelsayed
 
Hi Harald, I went to the previous link and i tried to write my question but i could not Because The replying options were not active, HOWEVER so please could you guide me where and what can i do Because I am really need this tool. Many thanks, Moelsayed
 
Hi Moelsayed,
in FAQ-area it's not possible to reply.

Libnodave
1. download Libnodave package from http://libnodave.sourceforge.net/
2. unzip Libnodave package
3. copy libnodave.dll to C:\WINDOWS\system32
4. take a look into the unpacked files - in folder "doc" you will find documentation, start with index.html
5. take a look into the folder "Excel And VB", open Modul12.bas with notepad.exe and read
(6. you can copy the Modul12.bas into your xls-file: open Excel + open Extra > Macro > Visual basic editor (or so) + file > file import)

Excel example
7. go to FAQ: Programmbeispiel für EXCEL 64-Bit und 32-Bit and download the attached file Tankanzeigen_mit_Libnodave_64.xls.zip
8. unzip
9. open the Tankanzeigen_mit_Libnodave_64.xls
10. go to sheet "Tanks" with an example for connect to S7-300 via CP343-1 or the PN-interface of CPU
11. change the red IP-address to IP of your PLC
12. put a DB123 with at least 8 REAL-variables in your PLC and manipulate the values in range 0.0 ... 40.0 or 65.0
13. click the button [Werte aus PLC lesen] --> this call the Sub readFromFAFM() in Modul10 --> this will read DB123.DBB0...DBB23 from the PLC and show in chart
14. read Modul10. there are short descriptions at the 32-Bit declarations. 64-Bit declarations are without description - see 32-Bit

Harald
 
Zurück
Oben