Hey guys I'm new here and pretty frustrated with trying to get some basic code going on a new project. I'm not very good at this stuff but I've done some VBA on my own usually by Googling something close to what I need and then messing with it to figure out how it works. However that requires something that works so I can manipulate it to see what changes etc.
I'm trying to use Excel 2010 VBA to connect to FXCM for historical Forex data. They have a Forexconnect API and COM, both of which I have installed as instructed to
c:\program files\candleworks\ForexConnectAPTx64
and have added the fxcore2_com reference through the tools menu in the VBA editor. This page contains their info on the COM and has links towards the bottom for the API and COM. There are samples provided in
C:\Program Files\Candleworks\ForexConnectAPIx64\samples\com\VBA
and there is a help file located at
C:\Program Files\Candleworks\ForexConnectAPIx64\doc\chm\ForexconnectAPICOM.chi.
First off, the sames don't load when you open the file from Windows explorer, only if I open them from within Excel. I started with the Login.xls and the Login part of the help file. Trying to replicate the code from the help file doesn't work and gives me a Run-time error '-2147024894 (80070002)': Automation error The system cannot find the file specified at the bold portion.
I have :
The help file has this:
1. Create an instance of the main COM class of library:
2. Create a session:
I have tried dealing with their online chat several times but they don't deal with this and I have emailed their API support who first sent me to the API download page which I had already been to and then told me that VBA is not VB which is irrelevant considering I specified I was working in VBA and had already downloaded the API and the COM so that I could use it in Excel. Any help would be greatly appreciated as I just want to get these sample files working, starting with the login so I can go about things as usual.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks