Message 1 of 3
Re: customize assembly

Not applicable
01-10-2015
05:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Code i used
SyntaxEditor Code Snippet
xlsPath=("PARAMETRY.xls") If PODNOSNIK = "MNIEJSZY" Then GoExcel.CellValue(xlsPath, "Arkusz1","B4")=840 GoExcel.CellValue(xlsPath, "Arkusz1","B20")=1800 GoExcel.CellValue(xlsPath, "Arkusz1","B25")=720 GoExcel.CellValue(xlsPath, "Arkusz1","B29")=1200 MultiValue.UpdateAfterChange = True GoExcel.Save ElseIf PODNOSNIK = "WIEKSZY" Then GoExcel.CellValue(xlsPath, "Arkusz1","B4")=900 GoExcel.CellValue(xlsPath, "Arkusz1","B20")=2000 GoExcel.CellValue(xlsPath, "Arkusz1","B25")=800 GoExcel.CellValue(xlsPath, "Arkusz1","B29")=1400 MultiValue.UpdateAfterChange = True GoExcel.Save End If
And then this kind of form. No going into .xls just choosing options in form. iAssemlby is also a solution
https://www.youtube.com/watch?v=1_d8Hl6z-j0