GeoEqual

I want to put the total on the last row of the sheet regardless the number of the records. If 10 rows are populated, i want to put total on 11th row. If 12 rows are populated, i want to put total on 13th row. If I based the adjustment …

i want to save the image together with excel file. Like this, this is my code converting vb report to word: ActiveDocument.Shapes.AddPicture FileName:="" & App.Path & "\logo1.jpg", Left:=140, Top:=0, SaveWithDocument:=True Is there an option on excel like "SaveWithDocument:=True"

this worked perfectly, thanks a lot can you please explain to me these 2 lines on your equation: sum(if(unit='cm',qty/100,qty)) qty, 'm' unit

.ConnectionString = "Driver=MySQL ODBC 5.2a Driver; SERVER=localhost; UID=asdsadafg; PWD=sadsadsJFKSKF9; DATABASE=SampleDB; PORT=3306; OPTION= 1 + 2 + 8 + 32 + 2048 + 16384 can anyone explain the OPTION, what this connetion string will do... i have no idea.. please explain

xlWSheet.Range("C19:K19").Merge xlWSheet.Range("C20:K20").Merge xlWSheet.Range("C21:K21").Merge xlWSheet.Range("C22:K22").Merge up to 54, thanks

here is my table in database: name qty unitcost totalcost A 1 10 10 A 3 10 30 B 2 20 40 B 1 20 20 here is what i want to view to user: name qty unitcost totalcost A 4 10 40 B 3 20 60