Excel process keeps running

Discussion in 'Software' started by jazzdrive, May 23, 2005.

  1. jazzdrive

    jazzdrive Private E-2

    In our Intranet site, someone can create and download and excel spreadsheet. However, on the server, this starts an Excel process that never ends, and so unless I manually end it, no one else can create and open a new excel file from the site.

    I've done everything I can in the actual code, but it doens't end the process. Does anyone know how to end process with a batch file. I want this to run every so often so I don't have to worry about manually doing it.
     
  2. Kodo

    Kodo SNATCHSQUATCH

    did you remember to set the excel object to NOTHING when the process is complete ?
     
  3. jazzdrive

    jazzdrive Private E-2

    Yes everything is set to Nothing.

    Here's the code towards the end.


    oSheet.Cells(rows+2, 2).value = "Created: " & Now()

    oSheet.ActiveSheet.Export ("D:\Intranet\Book1.xls")

    oSheet = Nothing

    Thanks.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds