Selection.ClearContentsRange("AL2").SelectActiveCell.FormulaR1C1 = _ "=BDH(RC, Sub PopulateData() PopulateData Macro Range("AL2:BQ2").Select #Word set macro shortcut keys codeI have a very minute amount of code below: I have been waiting for Bloomberg support to fulfill this request for over one month now with no results. What I would like to do is create a macro that will:ġ) clear all data in $AL$_:$BQ_$ & $BS$_:$CX_$Ģ) set the value of $AL$_ = "=BDH(AK$_,"PX_LAST",$D$1,$C$1,"DTS=h","dir=h")"ģ) wait until the data is populated into $AL$_:$BQ$_ before going to $AL$(+1):$BQ$(+1) if $AM$_ has a value then most likely the data has populated in that row.Ĥ) then when $AL$_:$BQ$_ is finished, do the same for $BS$_:$CX$_ Also, if I refresh the worksheet some formulas will be overwritten with static data! The problem with this is that for some reason the refresh is happening synchronously and I think this is causing havoc on the DDE connection and/or Excel. Other times, much of the data is missing and I am forced to select and refresh each $AL$_ field. Sometimes there is no problem and when I come into work the following day, the data is shifted forward by one day. I leave the workbook open as the Bloomberg DDE session remains open for 3 days even if the Bloomberg executable is not running. What is supposed to happen is that in $AL$3:$BQ$3 there will be prices for 31 days. Each day I populate 31 days of historical price data for 500+ stocks. I am trying to fix a problem that I am having with Bloomberg add-in for Excel. MyFontCol = 2 View 9 Replies View Related Asynchronous Execution Of Macro Row By Row Mar 7, 2013 What do I need to do to trigger it automatically whenever the worksheet change.ĭim c As Range, myFontCol As Integer, m圜ol As Integerįor Each c In ActiveSheet.Range("f7:g20000") I have this codes which will only trigger if I manually execute it. #Word set macro shortcut keys manualView 2 Replies View Related Change Manual Execution To Automatic Execution Jun 1, 2007 However I feel that defining a short-key would be much more productive. initially I had created an icon and had linked the same to this macro. The reason for this request is that after a lot of struggle I got a VBA code to work (as a macro). Is there any way to define a shortcut for an exisiting macro. When we record a macro it gives us a option to assign a shortcut key to that macro how ever that is only in combination of "Ctrl" my question is that is there a way by which we can use any other combination like "Ctrl"+"Shift"+ View 2 Replies View Related Assigning Hotket (shortcut) To An Exisiting Macro? May 9, 2006 View 4 Replies View Related Assigning Shortcut To A Macro Jan 29, 2007 note that this toolbar is only available to this workbook, so these macros are not available to the personal workbook. I have tried recording a macro and viewing the code, I tried applying this code there but it does not using the shortcut key. One of the changes is to allow shortcut keys to run these modules. ![]() I have been asked to make changes to this toolbar. I have a workbook that when I open it opens a toolbar that was designed for it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |