Questions tagged as 'vba'

Tagged questions
1
answer

Problem with possible macro excel vb [closed]

I am working with lots of txt files and I need a macro excel to do the following (if possible). I detail it: I have a path with different .txt with different names, this is an example    prueba1.txt       prueba2.txt       prueba3.txt  ...
asked by 08.09.2016 / 09:50
1
answer

Click on the web page button, there are 2 with the same ID

They could support me, I am making a macro in VBA and I need to give click in the CONFIRMAR button. The problem is that there are 2 buttons with the same ID and honestly I have no idea how to do it. I enclose the HTM...
asked by 21.12.2018 / 18:37
1
answer

execute code in all 3 sheets in excel

Good morning experts How can I add this code so that it executes at the same time on the 3 sheets when I make each number change in cell A1 Sub Controldenúmero1_Cambiar() Dim n As Integer For n = 1 To Len([A1]) BuscarÁrea n, Mid([A...
asked by 03.10.2018 / 00:17
1
answer

concatenate in vba to send by mail

I'm using the ShellExecute function that allows me to open a link from a macro in outlook, I need to be able to read the mail and send the information through a link where a server in php will process it How do I concatenate the x that has the n...
asked by 07.11.2018 / 19:08
3
answers

VBA reading a JSON

I'm trying to read a Json that returns a web service and show the data in an Excel using VBA. I call her with this: Dim hReq As Object Dim strUrl As String strUrl = "http://api.worldweatheronline.com/premium/v1/weather.ashx?key=db3927718fd...
asked by 21.09.2018 / 12:13
1
answer

Filters with Excel Macro

I hope you can help me with the following. I have a sheet in Excel, in which I need to make certain types of filters. Criterion 1: Column A; It contains dates and I need to filter the most recent date. The date is in this form "Month and D...
asked by 18.09.2018 / 21:56
1
answer

How to make a Macro that performs a search of a table in Ms Access?

I have a Access Database in which I look for registered users When I perform a search, it generates results, when I click to see the information, it does not generate any of the information I added. This is the macro that executes...
asked by 05.09.2018 / 20:47
1
answer

macro, join sheets of different books of excel

I am a macro researcher in excel, so far I consider myself a beginner in this work, I need your help to solve a problem. I need to merge several excel files into one, this I have been able to achieve with a macro like: Sub simpleXlsMerger()...
asked by 04.06.2018 / 19:53
1
answer

capture the text of a vba tag

I have a query, it is about a macro that I need to formulate, in it I need to gather the information of several sheets of a book in a single final book, in this I have no problem, my problem is that each sheet has a label with text, which I must...
asked by 06.06.2018 / 17:30
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