| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Jadin Lazarin
Caldari
Cassus Beli
Ethereal Dawn
   |
Posted - 2009.04.17 17:10:00 -
[1]
If anybody has any reference material or good examples of how to access the corp journal entries using excel vba 2003 I would eb greatly interested as I am struggling greatly and I lack the C# programming skills to make use of existing .net libraries.
|
Fubar
Eagle Eye Inc.
|
Posted - 2009.04.17 20:19:00 -
[2]
Eve_API_Retriever.xls provides a VBA module that can be integrated into your spreadsheet.
Modify it anyway you like. The test sheet provides only very limited examples of using the function.
Hope this helps.
|
Hel O'Ween
Academy of Truth
|
Posted - 2009.04.18 07:07:00 -
[3]
I'm providing the source code (Visual Basic 6) for EWA (see my signature), which also handles the journal data. You might be able to pick off the parts you need from there.
If you need help wading through that stuff, drop me an (out of game) email.
--
EVEWalletAware - an offline wallet manager |
Bambi
Existentialist Collective
|
Posted - 2009.05.07 15:31:00 -
[4]
Hey Fubar,
I have been trying to get your api retriever module to work, and you know me from previous harassment :), excel formulae mess with my head.
My problem is this, I have edited one of your test buttons to retrieve the char_WalletJournal api and replace the info on Sheet1 with the data retrieved, to this: (not my api info)
 Quote:
Private Sub butAllianceList_Click()
Debug.Print Eve_API_Retriever(char_WalletJournal, Sheet1, 45036, Ju5Xjp5S1blahblah, 125895465, account_1000, True)
End Sub
it seems to accept the user_id but fails on the apiKey, it tells me "Compile Error, variable not defined", and highlights the api key. Am I being a total numptee and going about this all the wrong way?
I am using Office 2007 if that makes any difference.
EVE is dead, long live EVE!
|
Melonar
Core Element
Blackguard Coalition
|
Posted - 2009.05.07 15:48:00 -
[5]
Originally by: Bambi
My problem is this, I have edited one of your test buttons to retrieve the char_WalletJournal api and replace the info on Sheet1 with the data retrieved, to this: (not my api info)
Quote:
Private Sub butAllianceList_Click()
Debug.Print Eve_API_Retriever(char_WalletJournal, Sheet1, 45036, Ju5Xjp5S1blahblah, 125895465, account_1000, True)
End Sub
it seems to accept the user_id but fails on the apiKey, it tells me "Compile Error, variable not defined", and highlights the api key. Am I being a total numptee and going about this all the wrong way?
If that is how it is appearing in your call to the function, I'd say that the issue is the lack of quotes around the apiKey. Since it is a string literal, it needs to be encapsulated in quotes, otherwise, it will consider it a variable (which has not been defined).
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |