I am an electronics hardware design engineer with little experience of programming.
The project has three sections.
1. Programming a Pic18F2550 with two AD7787 ADCs connected by 3wire serial port with chip select
The Pic must boot up as USB HID and start Main app.
Output from the AD7787s must be selectable and data transferred to main app.
Three 8x8 byte blocks must be transferable from EEPROM to main app.
I have a PicKit2 for programming.
2. Main app. Written in Visual Basic (I have 2008 express) with standard text window to display selected AD7787 data
Download the 3 8x8 bytes of EEPROM data to arrays.
3. Write Macros for MS Excel to initialise (open) data channel with Pic or Main app.
Send data to Pic or Main app. ( to control data flow and EEPROM)
Read data from Pic or Main app.( to read AD7787 data and EEPROM)
The communications can be either via the Main app or direct to the Pic
The objective is simplicity so that I can add sub routines to use the EEPROM data to calibrate the final instrument outputs.