Macro: Copy and Paste Boomberg Link
I am trying to create a macro that 'copies' a cell (that feeds off a Bloomberg link) in one worksheet and 'paste' into another worksheet. I don't need the link explicitly pasted but just need the value. Does anyone know how to do this? Much thanks! -- excelman ------------------------------------------------------------------------ excelman's Profile: http://www.excelforum.com/member.php...o&userid=26249 View this thread: http://www.excelforum.com/showthread...hreadid=395459 |
excelman wrote in
: I am trying to create a macro that 'copies' a cell (that feeds off a Bloomberg link) in one worksheet and 'paste' into another worksheet. I don't need the link explicitly pasted but just need the value. Does anyone know how to do this? Much thanks! Record the macro while doing a copy and paste special/value? -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
that is exactly what i want to do. works manually...does not work as a macro since bloomberg doesn't 'generate' the values prior.... i guess is there a code that updates the worksheet before i do the copy/paste? i think i'm missing an update code or something... -- excelman ------------------------------------------------------------------------ excelman's Profile: http://www.excelforum.com/member.php...o&userid=26249 View this thread: http://www.excelforum.com/showthread...hreadid=395459 |
excelman wrote in
: that is exactly what i want to do. works manually...does not work as a macro since bloomberg doesn't 'generate' the values prior.... i guess is there a code that updates the worksheet before i do the copy/paste? i think i'm missing an update code or something... If you do a refresh whilst recording the macro? Edit/Links etc. . . . -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com