Using Vbs refresh bloomberg data in an excel file and copy paste value the result from colum p to colum o
Posted on 2011-02-25
I was able to use a program from this web site that refresh the bloomberg data but i need to copy paste special tose data and save the file and close it. Can somoene help. it is the first time I used VBS.
Dim objShell:Set objShell=CreateObject("Wscript.Shell")
sRun="cmd /k Start excel " & chr(34) & "N:\TO\file.xlsm" & chr(34)
objShell.AppActivate "Window title" 'of the program's popup
objShell.SendKeys "~" 'send Enter key
Thank you very much for your help