Questions tagged as 'vba'

Tagged questions
0
answers

Error data type DLOOKUP

I have the following code in access Dim mes, año, tcambioOk As String tcambioOk = DLookup("TCambio", "TCambioDivisaDolar", "IdDivisa=" & divisa And "MesFechaLIKE" & "'" & [mes] & "' AND " & "Año =" & "'" & [año] &am...
asked by 07.02.2018 / 21:22
0
answers

Copy notes at the end in Microsoft Word

I want to copy the notes at the end of a Word document and paste them into the body of the text without losing the numbering. With this code I can do it (copy the notes at the end and change each reference number in the text) but I can not copy...
asked by 04.02.2018 / 15:48
1
answer

Error #Value based on excel

Good morning I am creating a formula that when writing a number called RTN, I returned the name after a web query, for example I put the number 08019002275485 in the RTN box and it returns the results of which I need the name "CONSULTING COMP...
asked by 19.01.2018 / 12:28
1
answer

Can the entire macro be stopped from a UserForm?

I have a project in VBA in which I am already preparing the outputs for errors and there is an error that can be generated in the initialization of a UserForm . Private Sub UserForm_Initialize() With Application.WorksheetFunction...
asked by 04.01.2018 / 22:22
1
answer

how to recover a VBA module and userform in excel after closing

I've been working on an excel file with a userForm for weeks, right now I saved it and when I closed it and opened it again (a few minutes later) the macro that opened it told me that the macro could not be executed, it might not be available or...
asked by 10.12.2017 / 09:23
1
answer

Count how many times I use a macro in Word

my problem is, I have a macro opens a UserForm that gives two options one to paste text and another to paste images. My problem arises when I want to create another macro, a counter that shows in an Msgbox how many times each one uses or at leas...
asked by 26.11.2017 / 01:52
1
answer

Pass data from a single column to several rows

Good afternoon, I'm trying to make a code so that taking all the data of a column, I convert them into several rows, that is, in the column I have Name1, lastname1, telephone1, Name2, lastname2, telephone2, ... and I want each record to show me...
asked by 03.11.2017 / 16:36
0
answers

look for exact number in columns according to number of the left part

I have this macro Sub busca_numeros() Rem busca numeros iniciando en la celda a1 Dim unicos As New Collection Set sorteo = Range("a2").CurrentRegion With sorteo For i = 1 To .Columns.Count numero = Val(.Cells(1, i)) On Err...
asked by 29.10.2017 / 14:25
0
answers

Problem vba excel 2010 works fine in step-by-step mode and not when executing f5

Dear, I have the following procedure to make labels with tbarcode when I execute it step by step or if I delete and re-add the object tbarcode10 works ok, when I execute it from button no. It has a loop to modify the data that crea...
asked by 25.08.2017 / 17:52
0
answers

Add rows with macros in EXCEL without having to set a base row to generate the others

I made the following code in VBA (visual basic for application) in EXCEl so that through an associated MACRO, it can generate rows from "copy" a "base" row. The code that I have elaborated is the following: Sub Afilacalcderegulacion() Active...
asked by 17.07.2017 / 19:33