How to reed data from 18F4550 EEPROM into EXCEL via PC USB interface?

[Bruce]

Hi Jellis00,

This was done on a 4550 and compiled with PBP v2.47. Look in LABXUSB.INC for config fuse settings. I had these commented because I used Microchips USB boot-loader. You can get rid of the DEFINE RESET_ORG 800h since you're not using the USB loader. Note there are a few routines in the PBP code that were just experimental also.

The 18F4450.INC was in there because someone requested it way back when I first put this together, and I compiled the Microchip USB loader for an 18F4450 for them.

Just use the 18F4550.INC file you have, and set config fuses to the same as in the LABXUSB.INC file.

The Readme.txt file has instructions for the vbskfr2.DEP and other related files. This is a VB skin program that gives the form the look it has.

It's a lot of reading, but it's all there. If you're using PBP 2.6 look for the changes Darrel mentioned, and make sure you use whatever include files are with 2.6.

[jellis00]

The Readme.txt file has instructions for the vbskfr2.DEP and other related files. This is a VB skin program that gives the form the look it has.

It's a lot of reading, but it's all there. If you're using PBP 2.6 look for the changes Darrel mentioned, and make sure you use whatever include files are with 2.6.

Thanks, Darrel...that clears up a lot of it.

However, I looked again in the Readme.txt file and although it explicitly tells you where to place most of the files, there is no instruction where to place the vbskfr2.DEP file. Since it is a "dependency" file I'm not sure where it goes. I found some info here
http://support.microsoft.com/kb/178354/en-us but it still doesn't say where to place the .dep file. Should it go into the PBP root folder or in my project file under the PBP root folder....or does it go somewhere in the Windows/system32 folder like the other files in the zip?

Not sure what you are referring to in your statement "look for the changes Darrel mentioned"...he wasn't one of the posts in this thread. Are you referring to some other post of his?

[chuck]

Why not use SD card ?, with the SD card you can create a CSV file and open it striaght up in excel. With SD card you can unplug oen insert another SD card to carry on taking the samples then you can just insert it to a card reader either fixed or usb sd card reader.
That's the way I would do it

[Bruce]

See this thread on USB changes to PBP 2.6: http://www.picbasic.co.uk/forum/show...5&daysprune=-1

I haven't used USB with PBP 2.6 yet, but there have been changes, and you may need a newer version of EasyHID also.

I dropped the .ocx in Windows/system, and just left the other vbskin files in the VB6 directory with the VB project files.

[ardhuru]

Hi, here are a few thoughts, some, all, or none of which might be of use.

1) The folks at Parallax have a free application, PLX DAQ (earlier StampDaq) that directly takes in data from the serial port and inserts them in a spreadsheet; you might have to play around with the data frame structures; http://www.parallax.com/tabid/393/Default.aspx If you use the CDC mode, the app might be able to take your data directly from the virtual com port, eliminating a USB-to-serial chip / adapter.

2) As Dave pointed out, again using CDC, you could spit out the data in your 3 columns in a 31 iteration loop, grab it on the PC with a terminal emulator (one that recognises virtual com ports), and simply copy-paste it into Excel. This technique I have tried (not with USB, with serial) to plot the discharge curve of a battery and works fine.

3) Take a look at Windmill software, http://www.windmill.co.uk/ as also another product from Parallax, http://www.parallax.com/ProductInfo/...1/Default.aspx

Regards,

Anand

[chuck]

Hi, here are a few thoughts, some, all, or none of which might be of use.

1) The folks at Parallax have a free application, PLX DAQ (earlier StampDaq) that directly takes in data from the serial port and inserts them in a spreadsheet; you might have to play around with the data frame structures; http://www.parallax.com/tabid/393/Default.aspx If you use the CDC mode, the app might be able to take your data directly from the virtual com port, eliminating a USB-to-serial chip / adapter.

2) As Dave pointed out, again using CDC, you could spit out the data in your 3 columns in a 31 iteration loop, grab it on the PC with a terminal emulator (one that recognises virtual com ports), and simply copy-paste it into Excel. This technique I have tried (not with USB, with serial) to plot the discharge curve of a battery and works fine.

3) Take a look at Windmill software, http://www.windmill.co.uk/ as also another product from Parallax, http://www.parallax.com/ProductInfo/...1/Default.aspx

Regards,

Anand

I was going to suggest that, But you would have to get written permission for bussiness use has you can us it and alter it for free for private use. If i remember there is one file that cannot be altered due to copyrights.
May be worth e-mailing them to ask and see what they say

[jellis00]

I was going to suggest that, But you would have to get written permission for bussiness use has you can us it and alter it for free for private use. If i remember there is one file that cannot be altered due to copyrights.
May be worth e-mailing them to ask and see what they say

Thanks, Chuck for ideas. Are you referring to Parralax or Windmill?

[chuck]

Thanks, Chuck for ideas. Are you referring to Parralax or Windmill?

I was referring to Parralax has this is a freeware not sure about the windmill software.
I've used the Parralax many of times and it really easy to use.