I have a worksheet with hundreds of Bloomberg formulas in it that I need to change regularly. I only need to change the date information, everything else stays the same (see the formula below). What I'd like to do is enter a new date in a cell and run a macro to change all the previous dates to this new date. A simple Find & Replace macro won't work because I need to update the formulas with dates from the prior two weeks (they overlap eachother using find/replace).
Here's one of the formulas I need to change:
=BDH("CL1 Comdty","PX_LAST","6/24/2011","6/24/2011","Dir=V","Dts=H","Sort=A","Quote=C","QtTyp=P","Days=A","Per=cd","DtFmt=D","Fill=P","UseDPDF=Y")
Basically, I want the macro to write the formula as you see it, but with a reference to a cell with the new date (e.g., change "6/24/2011" to some new date). Bloomberg requires the formula to appear EXACTLY as above.
I want to do something similiar to what I found in this thread but I'm having trouble getting it to work: http://www.mrexcel.com/forum/showthread.php?t=64290
I'm a relative newb with VBA. PLEASE HELP!
Here's one of the formulas I need to change:
=BDH("CL1 Comdty","PX_LAST","6/24/2011","6/24/2011","Dir=V","Dts=H","Sort=A","Quote=C","QtTyp=P","Days=A","Per=cd","DtFmt=D","Fill=P","UseDPDF=Y")
Basically, I want the macro to write the formula as you see it, but with a reference to a cell with the new date (e.g., change "6/24/2011" to some new date). Bloomberg requires the formula to appear EXACTLY as above.
I want to do something similiar to what I found in this thread but I'm having trouble getting it to work: http://www.mrexcel.com/forum/showthread.php?t=64290
I'm a relative newb with VBA. PLEASE HELP!
