- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 4
- Posts with Downvotes
- 3
- Downvoting Members
- 2
- Interests
- computers
- PC Specs
- i5 HD5770
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" |
|
Re:
this is the table ITEM QTY UNIT rod1 50 cm rod1 1 m rod1 50 cm rod2 25 cm rod2 75 cm rod2 1 m this is the result i want user can see ITEM QTY UNIT rod1 2 m rod2 2 m this is tricky for a newbie, please … |
|
.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 |