Progress bar in C# windows application

dampyr · June 10th, 2012, 10:35 AM

Hello,

i have batch file (142 lines total) syntax is similar to this:

copy something somewhere

start /min excel.xls
start /min excel1.xls
start /min excel2.xls
start /min excel2.xls

-----------------------

and so on

I have created c# Windows form with button which runs batch-all that's fine.However,i want to implement progress bar,which will read thru the bat file once to get the total number of commands in the bat file.
Set the progress bar max value to this value.
Re-read thru the batch file, and after every command is complete, increment the progress bar value by 1

I found Visual Basic code for this,but i would like C# code either.

Thanks in advance.

malie22001 · June 26th, 2012, 09:40 PM

Provide us with the VB code and we can probably interpret to C# for you.

Cheers!

dampyr · June 27th, 2012, 09:36 AM

Thanks,but there is no need for that,simply i have converted all dos command
to c# equivalent and all works fine now.

dampyr · June 28th, 2012, 03:18 AM

Hello,me again,

I have a bunch of excel files with macros,which executes on file open.Macro
connect to the database,refresh itselfs,save results to other workbook and close workbook,another workbook opens,do the same job,closes itself and so on.

c# code for this is:

Code:

  Excel.Application excelApp121 = new Excel.Application();
            excelApp121.Visible = true;
            Excel.Workbooks oBooks121 = excelApp121.Workbooks;
            Excel._Workbook oBook121 = null;
            oBook121 = oBooks121.Open(@"C:\@IT\Izvestaji\Uzice visual\TOP_50_OBST42.xls", oMissing, oMissing,
                oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
                oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);


            //Run the macros
            RunMacro(excelApp121, new Object[] { "auto_open" });


            // Quit Excel and clean up.

            oBook121.Close(false, oMissing, oMissing);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(oBook121);
            oBook121 = null;
            System.Runtime.InteropServices.Marshal.ReleaseComObject(oBooks121);
            oBooks121 = null;
            excelApp121.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp121);
            excelApp121 = null;

All works as expected,BUT (Always there is some "but" is possible to integrate
excel files into windows form application,not as separate excel application window.After some googling i found out that this is achieved using webbrowser control,using this control i can open excel file in application but macro wont run,is possile to run macro in webbrowsercontrol and to close it ?