Questions tagged as 'vba'

Tagged questions
0
answers

Bring "zeros" from the DB of a String sql-vba field

I searched through all the sites and could not find a solution. I have a project in VBA that brings data from SQL sql. The field I need to bring is a varchar type, so the variable in my project is of the string type. If I execute the query in...
asked by 25.10.2018 / 19:21
1
answer

Get cell value on the left Excel with VLOOKUP

I have a sheet with several sheets, where when writing a text in cell B20 of sheet 1, in cell A20 of that same sheet the value 1 must appear. These texts must be written in the range of cells from B20 to B25 and their values (quantities) in the...
asked by 22.10.2018 / 21:21
0
answers

Search error in mysql with visual basic .net

Good day, Send me this error    executereader the connection property has not been initialized the error sends it here%% of% Private Sub btnAgregar_Click(sender As Object, e As EventArgs) Handles btnBuscar.Click If (validarCampo...
asked by 17.10.2018 / 17:01
0
answers

Change the origin of the data of an existing Excel chart using VBA

I have an existing graphic, called GRAFICO_PARETO. This graph has a data origin, for example let's say from A1 to G20, and I have to change it for a different range, but not from the Excel front-end, but from vba. The code that I have tried is:...
asked by 10.10.2018 / 14:57
0
answers

Error using Application.Evaluation

I am using this instruction to try to find out if a cell has conditional format or not to be able to apply one format or another. I do it with this code that I put below, seen as an example on other websites, and it gives me an error of type 13...
asked by 04.10.2018 / 20:19
0
answers

excel 2016 + serial port

I am trying to make a program that communicates with a device through the COM3 port using vba. But there is no way for excel 2016 to have a serial port. It is urgent and important I would appreciate help please. Thank you very much.     
asked by 04.10.2018 / 17:10
0
answers

Disable Protected View in Excel from Visual Basic

When downloading the excel I have to configure the blocking options to be able to edit on the excel. Configuring the following: Click on Protected View Click on the red circle There is some property to enable from the code, so tha...
asked by 04.10.2018 / 20:53
0
answers

Access 2010 VBA: Modify the recordset that feeds a report

I have a report to which I want to change the recordset that feeds it from VBA, so from the form of the button that feeds it, I select a query called OTaller and I add it to the records that have certain Id filtro = "SELECT OTaller.*"...
asked by 28.09.2018 / 14:04
1
answer

The filter is not being applied VBA

I want the 5 filters to be applied on the sheet, but the last one (date filter) is blank even though the date is taking it correctly :( Any ideas? Sub Macro2() Dim hoy As Date Dim fechaVisita As Date hoy = Date fechaVisita =...
asked by 28.09.2018 / 00:00
0
answers

How to modify independent txtboxes and add them to table data?

I have an Access Database that calculates the time between two dates; but the dates that are calculated, are not added to any table. I can not find why they are not added. The form code Private Sub Comando8_Click() CalculaTiempoTra...
asked by 27.09.2018 / 17:56