Hi all,
I have a simple function below to put in different forumlas in different cells to get stock quotes. When I run this I get runtime error 1004 application-defined or object-defined error. The first formula goes through but vba chokes on the next formula: ActiveCell.Offset(I - 1, 4).Formula = username
What am I missing?!thx
==============================================================================
Please Login or Register to view this content.
Last edited by LATrojan; 04-26-2009 at 11:58 PM.
Trojan, be sure to go back to your original post, EDIT, GO ADVANCED, highlight all the code and click on the # icon. [code] and [ /code] tags on all code is a forum rule...
...Also, what's your code doing? My system indicates it is trying to launch "edemo.exe". What's that?
Last edited by JBeaucaire; 04-26-2009 at 11:37 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hey -Originally Posted by JBeaucaire
It's using the InteractiveBroker DDE for Excel to download stock quotes. I'm concatenating the strings needed to request the stock data and placing them in cells. As I mentioned it the first formula works fine. It's the second that's giving me problems.
Thanks Beaucaire!
Since I can't run that code because of the edemo.exe, just have to fiddle. Maybe one of these:
Sorry, I really am just skipping stones on this one.Please Login or Register to view this content.
It depends on where the active cell is. If it's in row 1, there is no cell above it.
What is the code supposed to do?
JB is referring to your prior thread, in which you have not responded to the several suggestions. Please do so.
Entia non sunt multiplicanda sine necessitate
The way I want to run it is to select a cell that has the ticker symbol of the first stock and run the macro from there. The code is supposed to update a stock price through the Interactive Brokers DDEs.
About the previous thread, sorry I forgot I had posted it to the general forum. I couldn't find it
Thanks!
Hi again. All of those give me the same error. If you just click No when that edemo thing pops up the code goes through. I'm just looking to get that formula in the proper cell. Basically I want the right cell to read "=edemo|tik!'id" (even without the actual data feed).Since I can't run that code because of the edemo.exe, just have to fiddle. Maybe one of these:
Sorry, I really am just skipping stones on this one.Please Login or Register to view this content.
It's something to do with the bar "|" and ' symbols. Because if I remove them it works. Do I need to use any special symbols like a backslash in C/C++?
Thanks!
I just did a quick google, on the examples I found none used the ' encasing the string after the tik!, is this definitely required ?
On an aside do not use Integer as a Data Type for a Row variable given the Integer boundaries (32767) are exceeded by the number of rows available in XL, although (highly) unlikely to cause an issue it can generate overflow issues if you have mass data...
further, in VBA the Integer type is converted to Long "under the hood" so it's actually thought to be slower than just using Long in the first place (ie Integer -> Long -> Integer slower than Long -> Long) - ie there are no advantages memory wise using Integer in XL, the only advantage is if you want to sanity check your variables (ie deliberately generate an overflow error for unexpectedly large variables)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi DonkeyOte - yeah the ' is required according to the documentation from interactive brokers. The strange thing is that it works on the first line and doesn't on the second statement.
Please Login or Register to view this content.
doesn't that make sense though ? ie the username has no closing '
I'm not pretending I know what it does, nor can I test, but this
yabba!'xyz'
makes sense if the ' is used to denote a variable or somesuch whereas
yabba!'xyz
doesn't as there's no closing ' which is what's happening with your username statement (I think) ... in your other line (that works I believe?) you have a closing '
That's exactly what it was!! Thanks DonkeyOte!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks