Questions tagged as 'vba'

Tagged questions
1
answer

VBA Doubt - Run-time error '91' [closed]

'Procedimento para o Comando Entrar Sub Entrar() 'converte texto usuario para minusculo - formando um padrao frmLogin.txtUsuario = LCase(frmLogin.txtUsuario) ' Primeira parte - Verifica os campos vazios If frmLogin.txtUsuario = "" Then...
asked by 27.07.2016 / 14:14
1
answer

Microsoft VBScript runtime error '800a01a8' Object required: '[undefined]'

I have a routine that was working normally in IE8, when updated to IE 11 it introduces me the following message:    Microsoft VBScript runtime error '800a01a8'       Object required: '[undefined]'       Microsoft VBScript runtime error '800...
asked by 14.01.2016 / 12:10
1
answer

How to delete / delete repeated lines comparing different cells?

I want to know how to delete a line that is repeated throughout my table. The image below may help Possible solutions: 1. Scroll through the Macro of file Excel1 to pass the data to the file Excel2 . Avoid insertin...
asked by 04.03.2016 / 16:30
1
answer

Syntax error in VBA [closed]

I need help to solve a syntax error in Visual Basic Excel, the command is as follows: Application.ScreenUpdating = False Dim wsh As Worksheet Set wsh = Excel.ActiveSheet Dim data As String Dim r As Long 'The row index r = 1 Do data = wsh.C...
asked by 18.01.2016 / 02:20
0
answers

Extract data from a web lead to Excel

I'm trying to extract quota data from the following site: link For this I am trying to use the site source code. The problem is that I can not find in the source code the information I need, such as the euro's quotation against the dollar....
asked by 28.06.2015 / 01:01
3
answers

Range in Excel VBA

I have the following code snippet: ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Users\Contoso\Desktop\ArquivosDoContoso.csv", Destination:=Range _ ("$A$1")) In the Destination:=Range _ ("$A$1")) part, how do I put the...
asked by 15.04.2015 / 13:38
0
answers

Access websites and extract contents to excel via VBA

Hello, I'm looking to learn how to tinker with websites and extract image values, or insert passwords and logins via VBA, but I do not know any of that. I would like to know if it is necessary to know HTML to do it, and if anyone knows some good...
asked by 01.07.2015 / 16:27
0
answers

Web Query on Site with Login

I need to access a site to do a web data import, but this site needs to login and whenever I leave the worksheet and enter again I have to edit the query and connect again! The idea was to make this connection automatically. Then I used a cod...
asked by 22.07.2015 / 05:51
0
answers

Sort in two-dimensional array in VBA

I have a two-dimensional dynamic array : Birth dates in the first dimension (column) and names in the second dimension:    Example:    MyArray (0,0)="01/05/1990"    MyArray (1,0) =   "Luisa Silva" I would like a sort method that I...
asked by 08.07.2015 / 00:52
1
answer

Problems to click links / buttons in IE using VBA

I have a problem to automate the download of data from a site using VBA. The first part goes well, the browser enters the desired page and inserts the criteria into a dropdown list. Just need to click on the search button, but the macro to witho...
asked by 25.09.2015 / 20:25