Questions tagged as 'vba'

Tagged questions
1
answer

Excel Conditional Format Icons, without Conditional Format

I want to occupy the icons of the conditional format, such as the green and red flag; but without occupying the conditional format. The idea is: If numero <= 0 Then 'rt.Interior.Color = RGB(0, 255, 0) 'Aquí va una Bandera Verde Else...
asked by 20.12.2016 / 22:31
1
answer

Open a report with several IDs

I have a Recordset that offers data with between 1 and 10 records. On the other hand, to call a report that shows on each page the data of its associated table given some Id's: DoCmd.OpenReport "ordentallerSobre", acViewPreview, , "ID IN (2...
asked by 27.09.2018 / 18:08
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
1
answer

How to compress an XML file in ZIP in VBA Excel?

I'm trying to compress an XML file into a ZIP file and I'm using the code below, but I'm running into the following error Indicate the error on this line Shell.Namespace(zipFile).CopyHere (xmlFile) Code: Sub CreateZipFil...
asked by 07.03.2018 / 19:19
1
answer

Error "Object variable or With block not set" in VBA

Searching, I have located how to download the files from an email to the folder I need, now I find the problem that is compressed in .zip and I have to unzip them to load them in the database. Searching, I have seen this code, which gives me...
asked by 08.04.2018 / 20:50
1
answer

How to filter a range of cells in VBA excel 2013

Hello everyone I am new to this and I am having problems in VBA Excel 2013. I need to filter a database on a sheet, according to values I have on another sheet of the same book, these values are in a range of cells. These values are constantly c...
asked by 11.07.2017 / 06:09
1
answer

Run Replace command in VisualBasics to replace a formula

I'm trying to create a macro and I have problems trying to use the Replace command when it affects a formula in VisualBasics. My situation is this: In column L I have calculations of slope of different ranges: =PENDIENTE(G33:G6...
asked by 26.04.2017 / 10:19
1
answer

Move an Array in several Sub in VBA

Good afternoon, how can I move an Array from one Sub to another Sub? When I do this. 'Aqui puedo ver el dato "perro"' Sub prueba_1() Dim myArray() myArray = Range("A1:A3").Value Print myArray(2,1) Call prueba_2 End Sub 'Aqui sale el er...
asked by 20.03.2017 / 17:12
1
answer

Use the value of a variable within the string of a query

Usually when I assign a variable to a constant I would do it in the following way. Dim user As Variant user = InputBox("Ingresa tu usuario de la PC") I am connecting data with Visual Basic and Access. In one part of the query I declare th...
asked by 06.03.2017 / 19:08
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