C#

private void button1_Click(object sender, EventArgs e)
{
Excel.Application exapp=null;
Excel.Workbook exbook=null;
Excel.Worksheet exsheet = null;
object misvalue =System.Reflection.Missing.Value;
      
string fname = Application.StartupPath + "rep.xls"; 
exapp = new Excel.Application();

if (!File.Exists(fileToOpen))
{
exbook  = (Excel._Workbook)(exapp.Workbooks.Open
         (fileToOpen,0, true, 5, _value,_value, false,Excel.XlPlatform.xlWindows, _value,false, true,_value, _value,_value, _value));
}    
else
{
 exapp.SheetsInNewWorkbook = 1;
}
            exbook = exapp.Workbooks.Add(misvalue);
            //active last sheet non-zero indx 
exsheet = (Excel.Worksheet) 
 exbook.Worksheets.get_Item(exbook.Sheets.Count);

            exsheet.Cells[1, 1] = "First Name";
            exsheet.Cells[1, 2] = "Last Name";
            exsheet.Cells[1, 3] = "Address1";
            exsheet.Cells[1, 4] = "Address2";
            exsheet.Cells[1, 5] = "City";
            exsheet.Cells[1, 6] = "PinCode";
            exsheet.Cells[1, 7] = "Phone Number";
            exsheet.Cells[2, 1] = textBox1.Text.ToString();
            exsheet.Cells[2, 2] = textBox2.Text.ToString();
            exsheet.Cells[2, 3] = textBox3.Text.ToString();
            exsheet.Cells[2, 4] = textBox4.Text.ToString();
            exsheet.Cells[2, 5] = textBox5.Text.ToString();
            exsheet.Cells[2, 6] = textBox6.Text.ToString();
            exsheet.Cells[2, 7] = textBox7.Text.ToString();

if (!File.Exists(fileToOpen))
{       
exbook.SaveAs(fileToOpen,Excel.XlFileFormat.xlWorkbookNormal, misvalue, misvalue, misvalue, misvalue, Excel.XlSaveAsAccessMode.xlExclusive, misvalue, misvalue, misvalue, misvalue, misvalue);
}
else
{
exbook.Save();
}
            exapp.Quit();
            releaseObject(exapp);
            releaseObject(exbook);
            releaseObject(exsheet);
            }

rachel_m wrote:

Thus can you tell me what I can do to resolve my problem?

rachel_m wrote:

In a C# 2010 console application it work works fine until it gets to a certain spot. Basically this console application calls another console application.

Here is what is happening:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;
using System.ComponentModel;

namespace eScripts
{
  class Run_e
  {
  private static String strConsoleAppLocation = "C:\\Program Files (x86)\\coname\\1.exe";
  private static String strWebServiceurl = "https://etest//WebService1";
  static void Main(string[] args)
  {
  Process eProcess = new Process();
  try
  {
  String Process_Arguments = null;
  eProcess.StartInfo.UseShellExecute = false;
  eProcess.StartInfo.FileName = strConsoleAppLocation;
  Process_Arguments = strWebServiceurl + " 164 " + cust1";
  eProcess.StartInfo.Arguments = Process_Arguments;
  eProcess.Start();
  eProcess.WaitForExit(1800);
  Process_Arguments = null;
  eDataContext rptData = new eDataContext();
  string[] PkgIDs = rData.Trackings.Where(c => c.Received_Date != null
  .Select(c => c.Package_ID).ToArray();
  foreach (string PkgID in PkgIDs)
  {
  String Process1_Arguments = null;
  Process Process1 = new Process();
  Process1.StartInfo.FileName = strConsoleAppLocation;
  Process1_Arguments = strWebServiceurl + " 10 " + PkgID;
  Process1.StartInfo.Arguments = Process1_Arguments;
  Process1.Start();
  Process1.WaitForExit(1800);
  Process1.Dispose();
  Process1_Arguments = null;
  }
  ateTime StartDateTime = rData.Trackings.Where(c => c.Error_Report_Date != null).Select(c => c.Error_Report_Date).Max().GetValueOrDefault();
  DateTime CurDateTime = DateTime.Now;
  string[] AddPkgIDs = (from rData.Trackings.where(c.tNumber.Substring(0, 3) == "dis"
  select TNumb).Distinct().ToArray();
  if (AddPkgIDs != null)
  {
  foreach (string AddPkgID in AddPkgIDs)
  {
  String Process4_Arguments = null;
  Process Process4 = new Process();
  Process4.StartInfo.FileName = strConsoleAppLocation;
  Process4_Arguments = strWebServiceurl + " 14295 " + AddPkgID;
  Process4.StartInfo.Arguments = Process4_Arguments;
  Process4.Start();
  Process4.WaitForExit(1800); //waits 2 minutes  
  Process4.Dispose();
  }
  }
    }
  
   catch (Exception e)
  {
  Console.WriteLine(e.Message);
  }
    }
  }

private static String strConsoleAppLocation = "C:\\Program Files (x86)\\coname\\1.exe";

private static String strConsoleAppLocation = "C:\\allcustomers\\country\\state\\city\customername\\1.exe";

rachel_m wrote:

I have a try catch block in the code that calls the second application.

rachel_m wrote:

Can you tell me what I can do to make certain the second assumption is not true