Questions tagged as 'macros'

Tagged questions
1
answer

Constant expressions to detect the presence and value of macros

I am making great efforts to translate the macros of my projects to constant expressions that can be used with if constexpr . At the moment I have achieved almost satisfactory results doing some tricks with macros, I start defining macros...
asked by 28.02.2017 / 12:50
1
answer

Macro outlook, automate email

Dear good afternoon, I would like to know if there is a form or method either by VBA or other means by which at a certain time Outlook automatically opens a new mailing sheet and that this process is automatically and consecutively. that is,...
asked by 13.03.2017 / 19:59
1
answer

How to insert a new row with data in an Excel spreadsheet

I am looking for help in a code that is complicating me a lot since I must use (at least I think so) the Range method. Find , which I have not managed to know how it works. What I need is a code with which you can enter new blank rows in an...
asked by 11.07.2018 / 17:40
1
answer

Macro to print report "n" times (Access)

First of all, thank you spend your time reading and / or answering my post. I'm new to forums as well as using Access. I am developing a bbdd that allows me to print product labels, depending on a delivery note number. I have created a mac...
asked by 14.12.2018 / 13:22
1
answer

Response.Redirect visual basic

I am new using macros, could you tell me if this is the right way to open a web page: Sub Reporte() Response.Redirect ("http://www.microsoft.com") End Sub I will get the following error:    Error 424 has occurred at runtime       Obje...
asked by 14.06.2018 / 18:47
2
answers

Error: VBA types do not match

I'm doing a macro that compares two columns at the same time to perform an operation, column A is of type Integer and column C is of type Date, the problem is that when closing the cycle it throws me the error of <Se ha producido el error...
asked by 08.11.2017 / 05:47
1
answer

VBA Select html element by classe

I need to access the value of an input and click on another with an Excel macro and I need to select the inputs through its class, since they do not have an id. I've seen googling that the .getElementByClassName () method exists, but there's no...
asked by 20.04.2018 / 22:47
1
answer

Date operations in Excel VBA

I was asked to perform a macro in VBA and I am having a problem that I have to perform an operation with dates, I recover the date in the format "hh, mm" [15:59 ] and trying to make a subtraction between two dates generates an error 13, that t...
asked by 14.09.2017 / 16:28
1
answer

How to find data and export it to another excel sheet

I am currently working on a code which should: Read the item that the user selects from a Combobox, for example: Go to a page called "MEMORIES ACT" and search for this item, in the columns "CJ" and "CK" (it is done in these 2 c...
asked by 27.07.2018 / 18:29
1
answer

Next and Previous buttons to navigate between cells with a yellow background

I would like to ask your help to make two navigation buttons, in the "next" button and the "previous" button, the thing is this: I have this search engine And each time the user clicks the "Next" button the program should go to the next...
asked by 23.04.2018 / 16:43