<div>
Thanks markdmac. :)<br />
<br />
Sid
</div>


<div>
<div class="content wysiwyg-content">
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. <br />
<br />
Dim objShell:Set objShell=CreateObject(&quot;Wsc<wbr />ript.Shell<wbr />&quot;)<br />
sRun=&quot;cmd /k Start excel &quot;&nbsp;&amp; chr(34) &amp;&nbsp;&quot;N:\TO\file.xlsm&quot; &amp;&nbsp;chr(34)<br />
objShell.Run sRun<br />
wscript.sleep 5000<br />
objShell.AppActivate &quot;Window title&quot; 'of the program's popup<br />
objShell.SendKeys &quot;~&quot; 'send Enter key<br />
<br />
Set objShell=Nothing<br />
<br />
Thank you very much for your help<br />

</div>
</div>


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.Run sRun
wscript.sleep 5000
objShell.AppActivate "Window title" 'of the program's popup
objShell.SendKeys "~" 'send Enter key

Set objShell=Nothing

Thank you very much for your help


Using Vbs refresh bloomberg data in an excel file and copy paste value the result from colum p to colum o

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.