Questions tagged as 'macros'

Tagged questions
1
answer

excel macro enter key

I try to make a macro run by pressing Enter . The idea is that when you press the Enter key, create a new row with a auto-numeric value. The problem is that when recording the macro, it takes the ranks . Is there any way for the macro...
asked by 23.05.2018 / 16:00
1
answer

Error 13 in macro: the types do not match

When creating the next macro to copy, from one sheet to another only the cells that meet the condition, the execution shows me this error:    "error '13': the types do not match" Code: Sub CondicionalTopTxx() Dim OrigenHoja As Excel.Wo...
asked by 10.05.2018 / 11:47
1
answer

VBA Get text fragment of an html element with id

I am trying to access a web page with a macro in Excel, enter a code in an input, press a button and copy the price resulting from the search. It is this last step that I do not achieve. The element that contains the price has the id #result_ok...
asked by 06.05.2018 / 22:36
1
answer

Download html table with vba excel

Hello everyone and thanks in advance. I'm trying to download a table to excel from the page mismarcadores.com. I've got a macro on the internet. The problem is that the html tag of the table has no ID, and whenever I execute the macro, the...
asked by 02.08.2018 / 20:42
1
answer

My macro does not run completely

I'm doing a macro that consists of deleting duplicate data from a column in excel, (keep the first data and delete the remaining data), the problem is that I have to execute the macro many times to perform the task completely, this is my code, t...
asked by 29.09.2017 / 05:52
2
answers

Search for registration using vba an Access form

again bothering, I'm learning a bit of vba, with macros in acces, what I try to do is that when entering the ID this make the corresponding query and show one of the fields in another text box, attached the image of the form and the code Howe...
asked by 17.12.2016 / 16:37
0
answers

Excel Macros - SubIndice out of range

I am developing a Macros in Excel that takes web addresses from a range of defined cells and makes a query, but when I take the address and make the query it shows me an error message    "Subscript out of range". This is the code I am wor...
asked by 26.12.2018 / 21:46
1
answer

VBA I have trouble calling a range that is on another page of my book

I wanted to do it in the following way: Selection.FormulaR1C1 = Application.Goto (ActiveWorkbook.Sheets ("TRANSFERS"). Range ("RangePara")) What I want is that the selection that I currently have is with the values of the dynamic range t...
asked by 23.11.2018 / 17:39
0
answers

Help making a macro that passes whole columns according to its heading

Hi, I have a problem with a macro that I try to perform, before I had it with the macro recorder but then the tables started to grow and the headers change places every week, so now I want to select an entire column according to the headline tit...
asked by 15.11.2018 / 00:04
1
answer

How to click on a web button that does not have id, class, tag, or name

The link page looks like the image, but I do not know how to call it from vba until the moment when it should do something like this used IE.document.getElementsByName("button")(0).Click But now I do not know what command to u...
asked by 14.11.2018 / 21:30