error in the C# code

Question

hi I wrote this code to open excel sheet using C#.net but ther is an error in the open function can you tell me what is it // Excel object references. private Excel.Application m_objExcel = null; private Excel.Workbooks m_objBooks = null; private Excel._Workbook m_objBook = null; private Excel.Sheets m_objSheets = null; private Excel._Worksheet m_objSheet = null; private object m_objOpt = System.Reflection.Missing.Value; //object definetion m_objExcel = new Excel.Application(); m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks; m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt)); m_objExcel.Visible = true; m_objBook.OpenLinks("c:/test2.xls",m_objOpt,m_objOpt); thanks

Answer 1

@Sundar

 

If client donot want to view any console window to be viewed on the screen then you can go for windows form.

 

Because whenever a console application ran, it shows a black window which might distract the client.

 

For this, change your project output to 'Windows Application' instead of console application.

 

This will let it run on background (without UI).

 

Good Luck! 

Answer 2

Without console App or windows app, the system has to do automatically. I will set the time. Each day by that time, the mail should passed

Answer 3

Elaborate your word 'Machine learning' in this case.

Answer 4

Is there any possibility of implementing Machine Learning ? For this ?

Answer 5

Thank you salman

Answer 6

Here Console will never popup each time. It will run everything in background. This is the best way and as per my understanding there is no other way.

thanks. 

Answer 7

My question is, is there any other way ??? The console should not pop up for each time.

Answer 8

Already You Created Console app right. So just create a Schedular and which will run in background.

thanks. 

Answer 9

Actually I am using task Scheduler for this. I need a better way if any ??. Because, clients does not want to view the console popup at each interval of time. The operatoin should be done automaically in back end 

Answer 10

You can either use Task Scheduler and set your interval or create a windows service.

 

I recommend to use Task Scheduler for this