title: VBS script just hangs from SQL SERVER AGENT ? Any ideas
body: <p>The script </p>
  
  <pre><code>Dim args, objExcel 
  Set objExcel = CreateObject("Excel.Application")
  objExcel.Workbooks.Open "C:\Imports\Test\Account.xlsb"
  objExcel.EnableEvents=False
  objExcel.Visible = True 
  objExcel.Run "Module1.Auto_Open"
  </code></pre>
  
  <p>Now this works like a dream by double clicking on it .</p>
  
  <p>It work from the command line like so </p>
  
  <p>wscript test1.vbs.</p>
  
  <p>By putting it on sql server agent and using proxy account with my windows permissiom it hangs ! </p>
  
  <p>Syntax used for operating commnd window for single job step </p>
  
  <p>wscript "C:\Imports\Test\Test1.vbs"</p>
  
  <p>Using sql server profile and windows task manager I can see a EXCEL32.exe connection and a wcript connection , but no end file produced . Running this macro usually takes 30 seconds.</p>
  
  <p>All I want to do is sql server agent is open an excel file and run the auto open macro.</p>