Forum Discussion
joffre
14 years agoRegular Contributor
Robert,
I have the following code:
On lines 10 and 12 I'll pick itens from one excel file to fill blank quotes. How will I do my loop and how will my lines will be after the code is ready to run?
Supose that my Excel File has the following itens:
Column 1 || Column 2
Row 1.1 || Row 1.2
Row 2.1 || Row 2.2
Row 3.1 || Row 3.2
Row 4.1 || Row 4.2
Row 5.1 || Row 5.2
Thanks.
Obs.: I don't understand why does my posts have so many spaces between lines.
I have the following code:
Sub CadCargos
1 'Set most common sentence to a variable
2 Set Cargos = Aliases.FPW5_CADCALC.Form1.MDIClient.cdCargos
3 'I open the form
4 Call Aliases.FPW5_CADCALC.Form1.MainMenu.Click("Tabelas|Cargos")
5 'I check "Mensal" RadioButton
6 Cargos.fraTipoSal.optMensal.ClickButton
7 'I press "Next Code" button
8 Cargos.btnProxCod.ClickButton
9 'Types description
10 Cargos.fraCargos.cboCargos.wText = ""
11 'Types CBOs code
12 Call Cargos.fraCargos.txtCBO.Keys("")
13 'This value will always be 1
14 Call Cargos.fraCargos.txtCodSind.Keys("1")
15 'Press Save button
16 Cargos.btnCadMod1.ClickButton
Sub RemCargos
On lines 10 and 12 I'll pick itens from one excel file to fill blank quotes. How will I do my loop and how will my lines will be after the code is ready to run?
Supose that my Excel File has the following itens:
Column 1 || Column 2
Row 1.1 || Row 1.2
Row 2.1 || Row 2.2
Row 3.1 || Row 3.2
Row 4.1 || Row 4.2
Row 5.1 || Row 5.2
Thanks.
Obs.: I don't understand why does my posts have so many spaces between lines.