"The format is 8 MSB in the first register and the two LSB in the second register. Let me know what you can do as it would be a great help even with only an 8 bit hex(FF) value. I don't want to use ascii because excel can't recognize it as a value. If excel could convert ascii into it's numeric equivalent that would work. Thanks a lot "
There should be no problem changing it from 8 bits to 10 bits ( 0 - 1023).
Ok i am going to start off by saying that i have no experience using PICs, so i dont have a full grasp over what is doable over what is not. I programmed this project using a 16 bit processor that had over 250 instructions and life was easy. Anyway my Visual Basic part of the project gets the ascii value from the microcontroller via RS232, automatically changes it to decimal vaules, splits up the decimal values into groups and shoots in those groups into the columns and rows of the Excell. example if you want to get 2 ATD readings at the same time for 2 different analog inputs and lets say both are 1023 or 5 Volts. You save h 31 to first location in RAM h 30 to the second and so forth until you save all 8 values then you call the SCI rutine to output and the Visual basic will get all of it and stop after it gets the 8th bit. If deriving 255 out of FF is too complicated using the PIC ( which i believe it is) then there is also a way for u to send the 'FF' as data and the visual basic can do the calculations to change it to decimal but, you would have to figure that part out.
I can try to make a few changes to the VB code and send it but i am very busy these days so maybe i can send it in 1 week. You can easily change the VB code slightly to suite your needs. Even if you never ever used VB before it is so easy to use you will pick it up very easily. My code only works with Office XP ( excel ) It is buggy with the other offices but works perfectly with Office XP. This weekend i will try and send it.
good luck
bye