Questions tagged as 'excel'

1
answer

Update Selenium Frame VBA

Expensive, How can I do to update a frame with Selenium in VBA? Refresh frame is an option that exists when you right-click on a frame. I can not update the whole window, just the frame.     
asked by 16.03.2018 / 13:35
1
answer

VBA - Max characters in the dropdown-list

' Validação Motivo Columns(motivo).Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:= _ "TESTE1;TESTE2;TESTE3;TESTE4;TESTE5;TESTE6;TESTE7;TESTE8;TES...
asked by 30.11.2017 / 18:10
1
answer

Check exact sum in a cell from a range

I have a range in Excel with N values. I also have a cell with an x value. Is it possible without using vba, that I know exactly which cells in this range that added up, result in the value of my highlighted cell? Example: The cel...
asked by 11.10.2017 / 23:41
1
answer

Error writing and reading file in CSV

I have the following problem writing a CSV file. The file looks like this:    NULL My File class import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.File; import java.io.FileInputStream; im...
asked by 17.11.2017 / 13:56
2
answers

Checking and filling Excel cells

I have the following spreadsheet as picture below, I would like to create a VBA to check if the content inserted in the cell range of that worksheet exists in the list of the second image below, if it exists, fill in the cell of the content of i...
asked by 05.09.2017 / 21:45
1
answer

How to separate edital String in Excel

I need to separate this type of String (Example): 1 Estruturas lógicas. 2 Lógica de argumentação: analogias, inferências, deduções e conclusões. 3 Lógica sentencial (ou proposicional). 3.1 Proposições simples e compostas. 3.2 Tabelasverdade. 3...
asked by 20.09.2017 / 20:13
2
answers

JSON for XLS in java

Is it possible to transform a JSON into XLS with java? I've done an algorithm that writes JSON to CSV, but XLS does not. If they can post libraries or examples.     
asked by 17.08.2017 / 13:20
1
answer

VBA: Placing a space before or after uppercase letters in a given text

I have a sequence of texts that represent customer names, but they do not have enough space between each word / name (for example: CarlosAlbertoGomes ). However the words can be differentiated because the first letter of each word is capitalize...
asked by 05.04.2017 / 19:00
1
answer

Excel SES returning # N / A

I'm creating a check to see if the weight value is between: =SES(FRETES!$I$3>1<30;21,75;FRETES!$I$3>31<50;27,91;FRETES!$I$3>51<70;35,54;FRETES!$I$3>71<100;47,72;FRETES!$I$3>101<150;76,27;FRETES!$I$3>151<20...
asked by 23.06.2017 / 15:01
2
answers

Insert text in the header of a worksheet from the text contained in a cell

To set the header of a worksheet, go to Page Setup > Header / Footer > Customize header. Let's assume that in the middle section, I want a title that is in cell A1 to appear. How can I do this?     
asked by 18.11.2016 / 12:14