Questions tagged as 'vba'

Tagged questions
1
answer

How to search the characters of a cell for a list of values

I have several cells with random characters 123456- foo # 1 -rfjas1 123456rfja- foo # 1 -s1 1- foo # 2 -23456rfjas1 123- foo # 3 -456rfjas1 123456rf- foo # 3 -jas1 I should look for the values foo # N these I have stored...
asked by 01.06.2018 / 18:45
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
0
answers

a code to save cells highlighted in yellow to the other sheet

as you can do a vba code to save highlighted cells from a range of cells to the next sheet depending on the number of cell "ac1" that would work as a header on sheet 2 I have this code that highlights the cells but I would like that when the pro...
asked by 25.05.2018 / 01:03
0
answers

Excel: Read .dbf file with Ms Query from other sources

Environment: Ms Office 2010, Windows 10 I have not been able to obtain the information from this database with a .dbf extension using Ms Query (from other sources), maybe my data source is misconfigured but I already tried with all the driver...
asked by 18.05.2018 / 17:11
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

dynamic tables with VBA jump error and follow

I have a dynamic table where there is a selection filter and I want to choose only certain ones, I know how to choose them but when there is not one, I get an error and it stops. Is it possible to make a Loop that travels all and selects only th...
asked by 15.05.2018 / 00:01
0
answers

Why the first record is replaced

When I enter a form a record is added to the indicated row but after that I add another record and replace it and I do not understand why I think the code is right. Function Insercion(Nombre_Completo As String, Domicilio As String, Telefono As...
asked by 17.05.2018 / 06:41
1
answer

Remove garbage from textBox with multiline in VB 2005

I have a TextBox with active multiline, to this textbox I have assigned the KeyUp event with the "Enter" key, with this the textbox content is passed to a global variable, and this in turn opens from another window; but when you open it in the o...
asked by 11.05.2018 / 19:23
2
answers

Export date to excel vba from a web page

I am trying to export from a web page ( link ) the data of the table 1 Colombian Peso Rates table . The problem is that I do not export the date. Someone can help me with that.Annex image of the table to export table and image after exporting t...
asked by 09.05.2018 / 21:05