Recent content by Mightyginger

User error. It was fine all along! I was just about to start parsing the data and I was checking the string in the locals window but it's length is limited there. So I assume that was the full string. DOH!

Actually, all good. Resolved the problem.

No, it's from a Windows application called "Bloomberg".

I am writing code in VBA to manipulate a Bloomberg screen. Bloomberg is a financial application with various data displayed on the screen. Everything was working reasonably well but I have the following problem when trying to copy the data from the screen: When I use the copy command in the...

Hi guys, Do basically on this website there is some data I'd like to be able to download. http://www.oenb.at/isaweb/report.do?lang=EN&report=1.2.1 At the bottom of the page are some parameters you can set for the time interval over which you'd like the data. Looking at the link at the top to...

So I have a spreadsheet that saves closing levels to CSV files. It was working fine until I rebooted the other day and ever since then every CSV file it saves is empty. Not sure if company IT have somehow "upgraded" my Excel without me knowing. We are running 2003 11.8169.8172 SP3. If I step...

Bump please.

Hi all, I have been trying to automate Solver in VBA with mixed success. The idea is that I want to loop through multiple rows. Each row has a range of variables to be changed and another cell has the net difference to be solved to zero. My issue is that once I hit the set number of iterations...

Well I am using the interpolation function multiple times in the spreadsheet. I tihnk the simplest solution would be just to have an append function that I could pass to the function. I was hoping I might be able to use the Union fucntion as a neat solution but still struggling. Not sure why it...

Hi Brad. Sadly that didn't work. I am still struggling to union two seperate ranges that aren't immediately next to one another. Combo was kind enough to try and help but I've not manage to take his hints to the finished product so still don't have something that works. Any thoughts?

The function is fixed. So I kinda have no option there and I am using that addin already for pricing feeds so it makes sense to use their interpolation addin too if possible. So might you be able to give an example of what you think might be the optimal way of handling sticking two ranges...

Sorry. I am trying to get this to work by trying .Areas and .Areas.Count Do you have a sec to give me an example for the code above please?

Actually. Is this right? It only seems to work if the two inputRanges are next to each other in the first place. So Ranges A1:A5 and B1:B5 work find but A1:A5 and C1:C5 don't when used as the input. Thoughts?

For those following this I basically had to end up writing a VBA function which uses "Union" which I had never used before. The code ended up being pretty easy in the end so think I'll use this function to do the trick. Code: Function AppendRanges(inputRange1 as range, inputRange2 as range) as...

Thanks Geoff but sadly didn't work. This particular interpolation function comes with Reuters so it's not an easy xll I can upload.