Macro: Copy and Paste Boomberg Link

E

excelman

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!
 
D

Dodo

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!
Click to expand...

Record the macro while doing a copy and paste special/value?
 
E

excelman

that is exactly what i want to do. works manually...does not work as
macro since bloomberg doesn't 'generate' the values prior....

i guess is there a code that updates the worksheet before i do th
copy/paste?
i think i'm missing an update code or something..
 
D

Dodo

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...
Click to expand...

If you do a refresh whilst recording the macro?

Edit/Links etc. . . .
 
Top