Questions tagged as 'macros'

Tagged questions
1
answer

Error (Subindice out of range) in Excel (Macros-Vda)

My problem is the following I try to make a button in which 1. Search Excel file 2. When selected, copy only the layers with data of the A range 3.se closing 3.y hit it in the current excel in which I have the macro Greetings. We are using...
asked by 25.07.2018 / 18:09
0
answers

perform a filter and execute it according to a button

How can I make a filter that, according to the press of a button, shows me the results as shown in the image according to the range "ai1: al217" ?, but I would like it not to be filtered in the 4-digit numbers with the x     
asked by 29.06.2018 / 00:19
1
answer

delete repeated words in 2 different cells

I'm stuck making a sheet in which I want to delete a series of words that I have in 2 different cells. En la celda A1 tendría GLUTEN, SOJA, En la celda A2 tendría SOJA, GLUTEN, SESAMO, PESCADO, I would like to get in a 3rd cell, A3: SÉSA...
asked by 26.06.2018 / 13:05
1
answer

Looking for a TextBox within a table in VBA - Word?

I have a table of a single column, in some rows I have some textbox assigned to a macro that works perfectly. But I need to check the number of the row in which the TextBox are located. Would it be possible? Thank you for your attention. G...
asked by 18.06.2018 / 12:23
0
answers

How can I run a Word macro, in Word, from Visual Studio Visual Basic, not VBA

Create a macro in word that causes some markers to change places and at the same time create a row in a table, but I want this macro to be executed from the program of visual studio 2010 by means of a button, I mean that from the program I edit...
asked by 18.06.2018 / 08:44
0
answers

Signing to a web page using macros

I'm trying to do the following: I'm creating a macro that links me to a web page. Sub Reporte() Dim ie As Object Set ie = CreateObject("Internetexplorer.Application") ie.Visible = True ie.Navigate "https://paginaweb.html"...
asked by 14.06.2018 / 19:30
1
answer

how to do vlookup in macros of two different excel books

Hello, good morning, my colleagues, I have a question that I have not yet been able to solve, it turns out that I have two excel books A and B, in one of them one record as a database and in the other a list of product codes and what I want is t...
asked by 25.05.2018 / 11:16
1
answer

Leaves in Macros Excel

I have a problem, I hope you can help me. I have a macro that I collect information from a sheet, in a book, and I take it to another sheet, from another book. Each sheet of origin is recovered with a loop. Up to this point, the problem is when...
asked by 21.05.2018 / 14:31
1
answer

Help in macro excel

I need to know how, after fulfilling the condition, you can copy the corresponding range and paste on another sheet. That is, if row 13, after the iteration arrives, fulfills the condition, the defined range of row 13 is copied and copied in the...
asked by 21.05.2018 / 12:58
0
answers

SAP from Excel macro looks different

I have recently learned to implement within an Excel macro a connection with SAP to extract the information that is necessary. The macro works perfectly but, while it is running, SAP looks differently, changes colors and missing elements. This i...
asked by 11.05.2018 / 21:09