Search results for query: *

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...

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...

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...

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...

Hi, I am using a function to parse and return parts of a string. The string would look like this "FEDF-JUN10-99.8125-CALL". I am using "-" as the delimiter and the function is below. All of that is fine. However. I then use another Sub routine to go through and output amd at one point it...

I have an excel spreadsheet which saves data hourly to an Access database using DAO 3.6. As I understand the limit on the size of the database I can use with DAO is 1gb. My database is currently at 950mb and will be through 1gb next month. I could move to ADO but I believe the limit on that is...

I have a database which stores hourly data. The field "Date" is the index field for the database but is a Double. It stores the date as a double where the integer part is the excel serial for todays date and the decimal part is the hour. So today would be 39580 and the decimal .17 for the hour...

Hi guys, this is going to be something trivial I've not done but I've looked over it several times and have no idea why it doesn't work. I use this sub CreateTable to create a new Table called StrTableName in database strDbName. It creates the field Date and the table fine but Date isn't a...

What I'm trying to do is every day I get sent an e-mail from the same person and these e-mails have prices for different types of things. An example of the format would be Square Rectangle Circle Red | 10 | 11 | 12 Blue | 13 | 13 | 14 Green |...

Hi, I have a sub that imports a text file with some numbers. I want to be able to see if a key is pressed - if it is then it's going to invert the numbers. So is there some way that basically someone can press and hold down, say, the Shift key and then click a button to run the macro and I can...

I have set up a problem in my spreadsheet and it's solving the problem for each column with each column being a different historic date in time where the data was slightly different, so it just loops through. The problem is this, despite having set SolverFinish KeepFinal:=1 in my code I...

Okay, so say I want to import a file from a location into my spreadsheet. Part of this involves copying some numbers across. Thats fine. Now, what I'd like to be able to do is hold down a key while the macro is running (Alt doesn't seem to affect the macro running at the moment, so I can run it...

I have a varialble called column which has the correct column number. The top row is always going to be 3 and the last row is always (no_months+3). I thought the following would work but it doesn't. The function it's using is an interpolation function where the inputs are CurveInterp(x vals, y...

I have an array Date(0 to 15, 0 to 1) and I want to dump it to two columns on a sepcific sheet, say sheet5. This command works Sheet5.Range("A1:B100") = use_this_array but i want it to be more dynamic so that I can specify which column should be the first one and what row should be the top...

This is quite a simple idea but before I write everything I just have a really quick question please. I have 7 cells which have prices in them, these are fed from reuters. Anytime one of the prices change I want to capture all 7 prices. I was going to do this in a database but would a text file...

Hi, I'm writing a bit of code to adjust that needs to use some sort of numerical iteration. I was just going to write my own, using vairable step size, although I'm sure it'll be pretty code and just wondered if anyone had a god one before I go and do it myself. Thanks, Neil.

Hi, I'd written my own interpolation functions in excel but because of the sheer number of interpolations I do on the sheet it's become a bit too slow. Does anyone have a dll that I can use as a plugin which does linear, loglinear and cubic interpolation please? I'd really appreciate any help...

This code seems very slow when I'm using lots of them. Does anyone have any faster code please? Function LinearInterp(T As Variant, Trange As Variant, LRange As Variant) As Double Dim i As Integer, max As Integer, j As Integer On Error GoTo ErrorHandler max = 500 For i = 1 To max...