roxnoxsox
08-07-2015, 02:01 AM
I have a large spreadsheet on Excel which I'm trying to automate using a macro. I'm using the BDP function to pick up prices in approx. 3000 cells and then copy and paste this as special values into a new spreadsheet.
The only problem is that when I run the macro, it copies and pastes before the formulas to pick up from Bloomberg have finished running so all I get is a bunch of cells with '#N/A Requesting Data'.
If I do this manually, I have to click 'Refresh Worksheet' under the Bloomberg tab at the top of excel. Is there any way of writing the Refresh worksheet function into my macro so that the formulas will actually calculate ?
The only problem is that when I run the macro, it copies and pastes before the formulas to pick up from Bloomberg have finished running so all I get is a bunch of cells with '#N/A Requesting Data'.
If I do this manually, I have to click 'Refresh Worksheet' under the Bloomberg tab at the top of excel. Is there any way of writing the Refresh worksheet function into my macro so that the formulas will actually calculate ?