Questions tagged as 'macros'

Tagged questions
1
answer

Reminders if a cell matches a date in Excel VBA [closed]

I am trying to develop an alert that reminds people to send a weekly report when certain dates (which are selected in column BA) are matched with the current day. The problem is that my message box is not showing, and even though the code see...
asked by 14.03.2017 / 16:05
1
answer

Button that counts and adds data Excel VBA

I have to make a form that when I press a button I add a product to a table for a purchase ticket For that use the following code Private Sub AMERICANO_Click() Worksheets("Ticket_print").Activate Dim L As Variant Dim MyCount As Long L = Hoja2...
asked by 09.06.2017 / 08:47
1
answer

How to define an Array in VB excel with a range?

Good morning community. It turns out that I am looking for a way to filter, that allows me to select several references to filter, that is, by means of a macro I indicate to my Excel file that I look for a client by reference number. Examp...
asked by 19.06.2018 / 00:26
1
answer

Run time error 13 Type mismatch

I have a problem with a macro that I am trying to make. You should look for a range of values that I give you in all the excel sheets and you should return the name of the sheets in which each value of the range appears. the error occurs when co...
asked by 02.01.2018 / 11:27
0
answers

Callout VBA word

I'm doing a macro in Visual Basic for word. I already have this code: Set Callout = ActiveDocument.Shapes.AddCallout( _ Type:=msoCalloutThree, _ Left:=170, Top:=119.5, Width:=widthsize1, Height:=heightsize1) Callout.Callout.Accent = msoFalse...
asked by 19.09.2017 / 08:22
1
answer

Format of text to message body

I'm doing a macro in Excel which is used to send a meeting with Outlook, everything works fine but in the body of the message I want the text to be formatted, for example to put the text of colors, with bold, etc. Which I have not yet achieved,...
asked by 10.08.2017 / 21:37
0
answers

QlickView Buttons - Macros

I'm working on Qlikview and I have a button that runs a macro that creates folders. But I need to make more buttons inside the same Qlikview document that copy and paste some files (that's already done) Then, I need at least 10 buttons ins...
asked by 16.03.2017 / 14:14
1
answer

Run a macro from a .bat

I wanted to know if it is possible to run a macro in Excel from a .bat file since I can not find a way to do it. The macro that I own works correctly but I need it to run when I run the .bat I would appreciate it if you know something,...
asked by 18.12.2018 / 17:43
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