Search results for query: *

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.

Ah. Well spotted!! Annoyingly there are two versions of the interpolation function. One does indeed take three inputs which is the X to find, X array, and Y array of values to be interpolated. Somewhat annoyingly that function only returns ONE X value. They then created another interpolation...

Thanks again. Do you think you might be able to help with my post "Possible to append two ranges into one?" in the same forum?

I am using an interpolation function which takes as an input the range of the data to be interpolated. So lets says it looks like this: Column/Row A B 1 1-Jul-10 10 2 1-Jul-11 20 3 1-Jul-12 30 etc So I would submit the range A1:B3 but lets say...

Sorry for the delay. Worked a treat. Thanks!!!

Hi, I am using an interpolation in Excel and as part of this it takes a range of X inputs and range of Y inputs. Now lets assume the function looks like this: =interpolate(B1:B8,C1:C8,D2) where the B column are my X values and C are my Y values and D2 is the X value I want to interpolate for...