progress bar please help me

[shamharis]

we some students are doing a project in vb6 using ms excel.in our project all the datas are stored and retrived from the excel file.in our project we have a excel file generating form .here we generates a excel file which size can be changed depending upon the input.we require a progress bar i should progress while the file is saving to the hdd.please help us.
thanks in advance

[manavo11]

How do you have the data in your program? In an array?

[shamharis]

datas are taken from the origin excel file and stored in the array from there we will transfer to another excel file(like data abstraction) we need the data transfer progress bar size is un known may vary each time

[manavo11]

With UBound you can get the biggest index of the array. Then you can set the Min property of the progressbar to the LBound of the array and the Max property to the UBound of the Array. Then in your loop that would be from LBound to UBound, you set the Value property property of the bar to the index of the loop.