Home > Cannot Run > Cannot Run The Macro Blpmain.xla

Cannot Run The Macro Blpmain.xla

I have a very large number of links listed in that window, but the status says Not Applicable or Unknown for all of them. How to grep two numbers from the same line at different places using bash? more hot questions lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Other Please try the request again. his comment is here

How about recording a macro while you "click on every column to manual refresh" and then assign that macro to, say, Ctrl+R. I have tried all items commented out and still nothing seems to work. I have all the code for saving the snapshot, but getting the data for the one index to refresh is proving difficult. Was a massive case of voter fraud uncovered in Florida? http://stackoverflow.com/questions/7660971/click-refreshworkbook-on-bloomberg-ribbon

add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted What I ended up doing was re-pasting down the bloomberg formulas in the appropriate ranges. Doing it manually will change the status in the edit-links-windo to OK. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 1st, 2012,09:23 AM #4 Benjaminmin Board Regular Join Date Nov 2009 Posts 114 Re: Refresh sheet macro break How can I do this from code?

Nothing seems to work. Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦ MS Excel A Better Concatenate Function Article by: aikimark First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. More on Networks Information for network end users, and supplements to the 6.x and 7.x Network Guides End User Setup Install and configure your client or workstation software.

There are green ticks in the cells and am thinking I may need to format the cells to numeric. All contents Copyright 1998-2016 by MrExcel Consulting. I think the latter would be the optimal solution for me! http://microsoft.public.excel.programming.narkive.com/2viEGcRf/refresh-bloomberg-data-in-an-excel-file-from-a-script Here you go...

Reply With Quote Feb 1st, 2012,09:14 AM #3 Richynero Board Regular Join Date Jan 2012 Posts 114 Re: Refresh sheet macro break I agree with CCC. I'm using Excel 2007 and I found one option of entering Application.Run "blpmain.xla!RefreshAllStaticData" but blpmain.xla can't be found. How safe is 48V DC? The code shown/used is an example of how I thought intuitively/simply it would be written out.

Did a thief think he could conceal his identity from security cameras by putting lemon juice on his face? why not try these out I am new to VB/coding and for the life of me I cannot get the code to function in the intended way even after modeling from the examples I have found. Get 1:1 Help Now Advertise Here Enjoyed your answer? Dylan All times are GMT +9.

These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs). this content So you can click on a button you make that takes the data and adds a day and then removes it back. The time now is 08:28 AM. If those answers do not fully address your question, please ask a new question.

Why is looping over find's output bad practice? Code: Sub finishbbg() ' ' finishbbg Macro ' Macro recorded 01/02/2012 by benjamins ' ' Sheets("Upload").Select Application.Run "RefreshEntireWorkbook" I NEED SOME BREAK HERE Select Case MsgBox("Done! On Error GoTo errHandler Range("A8").Select With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;\\ABC.txt", Destination:=Range("A8")) .Name = "ABC" .FieldNames = True weblink lack of responses on this site is often down to a lack of detail in the question.

February 14th, 2007 dylanemcgregor Re: Macro To Force Refresh Bloomberg Data I found this useful bit of information on Bloomberg for anyone who might search for this later: Quote: Originally Posted Save the sheet; Go to ZEN; Load Prices") Case vbYes 'Do Nothing Case vbNo 'Do Nothing Case vbCancel 'Do Nothing End Select End Sub However, when I run it I get I can't try again until 11:00 PM tonight, but I will check this again then and see if it was just updating slowly the last time I tried.

So I am turning to the Experts to see if there are any suggestions.

On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor in a surprise attack? Ozgrid Retains the Rights to ALL Posts and Threads ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.6/ Connection to How can I go about this? Source Once you've done this, you can refer directly to the xla function RefreshAllStaticData.

February 9th, 2007 dylanemcgregor Re: Macro To Force Refresh Bloomberg Data Thanks. I will keep trying things. Updating may take a while, so be patient. check over here So probably I just need to use the code you wrote in your last post, but Im just not sure how to combine that with my message box.

Once the RefreshEntireWorkbook routine has finished it will continue with your little Select Case MsgBox. I've clicked on update links anyway, but nothing seemed to happen. Generated Tue, 08 Nov 2016 12:23:38 GMT by s_wx1196 (squid/3.5.20) Draw a hollow square of # with given width My cat sat down on my laptop, now the right side of my keyboard types the wrong characters addFieldToFilter() And Condition in