Community discussion forum

Excel Issues

• • Reply

  9 months ago

  by patorjk

  Patrick Gillespie

  , United States

  Joined 1 year ago

  I have a referrence to Excel 12.0 Object Library in my application. I have made the visible set to false for Excel and doing all my work. When iam trying to terminate the excel while application termination it is closing all the other opened excel workbooks.

  Please give a solution.

  The code is somewhat like this:

  Try

            Dim pProcess As Process

           exlHandle = oexcel.Hwnd

           GetWindowThreadProcessId(exlHandle, exlProcessId)

           pProcess = System.Diagnostics.Process.GetProcessById(exlProcessId)

          pProcess.Kill()

  Catch ex As Exception

          Return

  End Try

   

  Thanks in Advance

  Murali Krishna

  Report abuse
• • Reply

  8 months ago

  by Slicksim

  Simon Cooper

  Lancaster, United Kingdom

  Joined 4 years ago
  Hi, If you are using the Excel sheet via Com, then you really shouldnt end the process. It would be better to call close on the excel object you created using Com. Excel runs as an MDI application, therefore any new workbooks that open are opened in the running Excel instance. Killing it will kill all other Excel windows. The exception to this is when Excel is started by itself, this will create another Excel container instance, which makes finding out which instance actually hosts your workbook a nightmare and from what i understand, impossible. Regards Si
  Report abuse
• • Reply

  8 months ago

  by patorjk2

  Patrick Gillespie

  Baltimore, United States

  Joined 8 months ago
  For kicks, I decided to set up a Google Alert on the term "patorjk" (my website name if you add a dot com) and got an alert about this webposting. My first thought was "oh wow, another patorjk". However, I looked at your profile info and it says your name is "Patrick Gillespie" and that you are from Baltimore. There's close to a zero chance that there's another Patrick Gillespie from Baltimore, who programs in VB, that decided to use the online pseudonym "patorjk". Why is it that you decided to use my online pseudonym and why sign up for an online account with my information? That's very creepy from my perspective. It looks like you set up the account 7 months ago and made posts with no signature, but then since one month ago you've started identifying yourself as "Murali Krishna". I'd appreciate it if you would discontinue your use of this account and create one that actually represents yourself. Google Cache page of you saying your "Patrick Gillespie" from Baltimore: http://64.233.169.104/search?q=cache:DtOlJJ2knz0J:www.developerfusion.com/profile/patorjk/+patorjk+site:developerfusion.com&hl=en&ct=clnk&cd=1&gl=us
  Report abuse