C#

private void weeklyTimer_Elapsed(object sender, ElapsedEventArgs e)
        {
            eventLog1.WriteEntry("W event elapsed @ " + e.SignalTime); //<<---Debug
            createXLS(dirXLS_W);                      
        }//-----------------------------------------------------------------------
		
		 private void createXLS(string dir) //call before connection closes 
        {
            string data = null;
            Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            object misValue = System.Reflection.Missing.Value;

            xlApp = new Excel.Application();
            xlApp.DisplayAlerts = false;
            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
            eventLog1.WriteEntry("Xls worksheet created."); //<<------------------debug
            xlWorkSheet.Cells[1, 2] = "Date"; 
			// .. cells created etc. 
            
            try
            {
                xlWorkBook.SaveAs(dir, Excel.XlFileFormat.xlWorkbookDefault, misValue, misValue, true, false, Excel.XlSaveAsAccessMode.xlNoChange,
                                   Excel.XlSaveConflictResolution.xlLocalSessionChanges, misValue, misValue);
                xlWorkBook.Close(true, misValue, misValue);
                xlApp.Quit();
                eventLog1.WriteEntry("Excel file is saved under " + dir); //<<-debug
            }
            catch (Exception e)
            {
                eventLog1.WriteEntry("createXLS error: " + e.ToString());
            }
            
            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);
        }//--------------------------------------------------------
		
		private void releaseObject(object obj)
        {
            try
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
                obj = null;
            }
            catch (Exception e3)
            {
                obj = null;
                eventLog1.WriteEntry("Exception Occured while releasing object " + e3.ToString());
            }
            finally
            {
                GC.Collect();
            }
        } //-------------------------------------------------------------------------

byte[] receivedBytes = new byte[1024];
            int portno = Convert.ToInt32(txtportnum.Text);

            IPHostEntry ipHost = Dns.GetHostByName("192.168.x.y");
            IPAddress ipAddress = ipHost.AddressList[0];
            IPEndPoint ipEndPoint = new IPEndPoint(ipAddress, portno);
            txtstatus.Text = "Creating socket object...";

            Socket send_soc = new Socket(AddressFamily.InterNetwork,
SocketType.Stream,ProtocolType.Tcp);

            send_soc.Connect(ipEndPoint);
            txtstatus.AppendText("\nSuccessfully connected to:" + "\t" + send_soc.RemoteEndPoint);
            txtstatus.AppendText("\nConnecting via :" + "\t" + send_soc.LocalEndPoint);

            

            string sendingMessage = "abcde";
            SendMessage(send_soc, sendingMessage);
            
            int totalBytesReceived = send_soc.Receive(receivedBytes);
            
            
            string dff = "";
            
            string s = System.Text.UTF7Encoding.UTF7.GetString(receivedBytes, 0, totalBytesReceived);
            txtRx.AppendText(s);
            send_soc.Shutdown(SocketShutdown.Both);
            send_soc.Close();
            try
            {
                FileStream dr = new FileStream("E:/Demo/IpData/Call.txt", FileMode.OpenOrCreate, FileAccess.Read, FileShare.ReadWrite);
                StreamReader fg = new StreamReader(dr);
                string df = fg.ReadToEnd();
                dff = df;
                fg.Dispose();
                dr.Dispose();
            }
            catch (Exception dfjdfs)
            {
                throw dfjdfs;
            }
            try
            {
                File.Delete("E:/Demo/IpData/Call.txt");
            }
            catch (Exception jhu)
            {
                throw jhu;
            }
            try
            {
                FileStream cd = new FileStream("E:/Demo/IpData/Call.txt", FileMode.Create);
                StreamWriter cdf = new StreamWriter(cd);
                cdf.Write(dff);
                cdf.Write(s);
                cdf.Dispose();
                cd.Dispose();
            }
            catch (Exception hgy)
            {
                throw hgy;
            }
           
        }