Hi guys,
I'm a bit newbie in VBA but I'm sure that this macro will be straightforward for you guys.
I got a basic Excel spreadsheet named "Tester".
I just want to check in my bloomberg window named "3-Bloomberg" the ISINs beginning by "XS" or "US" followed by 10 figures/letters. The macro will copy these ISIN taken from this bbg window into my Excel in cell "B3".
For example, I got in my bloomberg window this list :
KOMIPW 2 3/4 02/11/19 XS1030877911
ICBCAS 3 7/8 09/10/24 XS1105630518
CITICS 3 1/2 10/30/19 XS1130968453
VEDLN 6 3/4 06/07/16 USG9328DAF71
RCOMIN 6 1/2 11/06/20 XS1216623022
KDB 3 3/8 09/16/25 US500630CG15
The macro will check the bloomberg windo, take all the ISINs :
XS1030877911
XS1105630518
XS1130968453
USG9328DAF71
XS1216623022
US500630CG15
An copy them in cell "B3" (Spreadsheet "Tester").
Thanks vm for your help
I'm a bit newbie in VBA but I'm sure that this macro will be straightforward for you guys.
I got a basic Excel spreadsheet named "Tester".
I just want to check in my bloomberg window named "3-Bloomberg" the ISINs beginning by "XS" or "US" followed by 10 figures/letters. The macro will copy these ISIN taken from this bbg window into my Excel in cell "B3".
For example, I got in my bloomberg window this list :
KOMIPW 2 3/4 02/11/19 XS1030877911
ICBCAS 3 7/8 09/10/24 XS1105630518
CITICS 3 1/2 10/30/19 XS1130968453
VEDLN 6 3/4 06/07/16 USG9328DAF71
RCOMIN 6 1/2 11/06/20 XS1216623022
KDB 3 3/8 09/16/25 US500630CG15
The macro will check the bloomberg windo, take all the ISINs :
XS1030877911
XS1105630518
XS1130968453
USG9328DAF71
XS1216623022
US500630CG15
An copy them in cell "B3" (Spreadsheet "Tester").
Thanks vm for your help
