Questions tagged as 'excel-vba'

Tagged questions
1
answer

Increment in String in VBA excel

A Strign in VBA excel has the following value: "T110A17014". I need to increment this string with each iteration. To increment only the last position the code below works! Now if we have this value: "T110A17099" and use the code below it will lo...
asked by 28.08.2018 / 07:47
1
answer

Update PivotTable with connection to a Stored Procedure using VBA Macro

I aim to bring the data from a Stored Procedure to a worksheet in Excel. This Stored Procedure is using two parameters for the query. Excel 2013 SQL Server What I have I mounted a macro that queries the database, updates a table with...
asked by 09.07.2018 / 16:49
1
answer

Function of converting decimal numbers to extensions using VBA in Excel

I have a function, = SpellNumber (), which when I put a number there, it drops the number in full. Agr, she looses, on the part of the cents, and X Cents. I wish she would let go with X / 100. Does anyone know how I change the code for her to do...
asked by 16.07.2018 / 18:52
1
answer

Separate numbers and words

I have a database in excel where in the row / column I have dates and words. Also, with dates before 1900. And, in some instances, only the year with 4 digits. Example: "A1" 20-07-1882 Daniel or "A2" 1882 João I use, to separate th...
asked by 11.07.2018 / 09:19
2
answers

Copy data from one worksheet to another

I have a problem in a macro, I'm trying to copy data from one worksheet and paste it into another one, but it's giving an error when inserting a new line (in yellow). Sheets: Code:SubcopiarDadosEntrePlanilhas()Application.ScreenUpdating=Fal...
asked by 23.04.2018 / 14:10
1
answer

VBA Filter Function

I'm using the code below to check if an element is in an array related to a Range. It turns out that in some cases the result is = 0 showing that it exists, but it does not exist. What's wrong? Instead of this function should I go thro...
asked by 18.04.2018 / 16:02
1
answer

Is there anything wrong with this code?

Function Check() Dim valorA, valorB, valorG, valor2 As String Dim rng As Range valorG = Cells(ActiveCell.Row, "G").Value valor2 = Cells("2", ActiveCell.Column).Value For Each rng In Range("A3:A321") Do While rng <> "" valor...
asked by 09.04.2018 / 02:33
1
answer

VBA / Macro - Cleaning Data [closed]

Hello, I'm here here breaking my head on how to modify a spreadsheet through a macro. Can someone please help me? I have a worksheet (Plan1) that have the formatting A1: AF720. I need to create a macro so that it is split into several other s...
asked by 24.04.2018 / 14:03
1
answer

Does not find element with findElementById

Expensive, I'm trying to fill two text fields (login and password) of a particular page. Using the following code. (Both by byID, bySelector, none works) driver.findElementByName("usuario").SendKeys MyLoggin When debugging the code, when...
asked by 28.02.2018 / 16:46
1
answer

Select option select

Expensive, I'm trying to select an option on a select with the following code and I can not find a solution. I can find the element, but do not tell it to select X option. I'm locating with the following code: driver.findElementByXPat...
asked by 01.03.2018 / 23:14