Search results for query: *

Here is the updated version with progress bar Private Sub Form_Load() ProgressBar1.Max = GetSetting("Book", "book", "total") End Sub Private Sub Start_Click() Timer1.Enabled = True End Sub Private Sub Stop_Click() Timer1.Enabled = False End Sub Private Sub Timer1_Timer() Text1.Text =...

Ok I think I came up with something... It just worked for me but I couldn't test it proparly, you will though since you said it takes a while to generate printing report. this can be added to module in Excel Public intVal As Integer, intTotal As Integer Public Sub savetoreg() a = 1 Do a = a +...

Ohhhhhhh I see now, yes I did misunderstood you. But that is really interesting question! I'll try to come up with smth

Hey JC As I understood your application is running inside Excel as Macro right? I'm working on the same thing, anyways if you inside Visual Basic Editor, here are the steps... http://68.198.213.153:2121/decal/vb/step_1.jpg http://68.198.213.153:2121/decal/vb/step_2.jpg...

Thanks A LOT MAN!!! how in the world did i missed that... thanks again

The code that you wrote gave me "F1" everytime it goes through the loop... Is there something I should do with it? THanks

Try this Dim cnnExcel as ADODB.Connection, rstExcel as ADODB.Recordset Dim item, fee set cnnExcel = New ADODB.Connection set rstExcel = New ADODB.Recordset With cnnExcel If .State = adStateOpen Then .Close .Provider =...

Hey, its really strange why would you want to call your program as "something.ABC" ???? That would mean you won't be able to run it... There are programs out there that can actually change icons of .exe files and hide the extensions but hey that's hacker's stuff ...

Hi, I encountered this weird problem ... For some reason when I run the code below when going through records it skips the first one and shows the second one and so on??? This is what I have in Excel Sheet1: A 1 666 2 555 3 444 4 333 So basically it skips 666 ?? Code: Dim...