Bloomberg spreadsheet not updating
Quit why not build an autoopen macro in the spreadsheet that refreshes the data when the workbook is opened Then your script just has to open spreadsheet (the autoopen could save it's self and send it's self as an email as well then close it's self) I take it the script is so this update can occur automatically Always Test on a copy ALWAYS No warranty or guarantee is explicitly or implicitly implied You accept and use any code or solution at your own risk If you are given a solution beyond your current skill level use with an appropriate level of caution and if using at your place of work it is your responsibilty to inform others of any support or understanding shortfall due to the source of the solution.I am copying formulas into a worksheet to get Bloomberg data, but the data is not refreshing. I have all the code for saving the snapshot, but getting the data for the one index to refresh is proving difficult.
Click "OK." Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine.
I was instructed to use VBScript to automatically refresh the data and then use Windows Task Manager to run this task daily.
lack of responses on this site is often down to a lack of detail in the question.
Open "C:\Users\Kern\Documents\Turtle Trend" obj Excel.
Add("C:\blp\API\Office Tools\bloombergui.xla") obj Excel. Can you help me on this, can you share a working code with me?
While you can certainly copy and paste data from a network or Web-based external source into Excel, importing the data by connecting to it provides an added benefit.