[jamesblue]

Can anyone explain with detail how to to do this?

I want to load real time data into a spreadsheet, and then add some VBA coding. First, things first, though how do I get the code in Excel.

I tried using the wizard data connection but it doesn't seem to take my user name and password that BarChart gave me.

Thanks,

James

[statsign]

http://realtime.barchart.com/mri/ax3/BarchartX.xla

[jamesblue]

Thanks Statsign - That's very generous of you.. It shocks me that I get this answer from a forum user in less than 1 hour and BarChart still hasn't responded to my same request now for over 1 week... But what you sent me seems to be going in the right direction.

I downloaded the .xla from BarChart.com but I can't see how to connect it.

I understand that .xla files are extensions that enable certain functionality (in this case the data feed).

But when I open a new spreadsheet, I don't see in the "data" tab of Excel, either in "From other sources" or "Existing Connections" where to add this next .xla extension.

What am I doing wrong?

James

[statsign]

Barchart Real-time Data Services: Troubleshooting