Questions tagged as 'vba'

Tagged questions
3
answers

VBA Subindices out of range

I have a problem, to see if you can help me. I have several xml files, which I'm dealing with one by one. I take the first one I try and I keep his information and when I finish crossing it I go to the next, and so on until I no longer have m...
asked by 17.07.2017 / 18:43
0
answers

Pacman in visual basic for applications

I have a drawback I'm doing pacman in visual basic of excel , what I have is that when I press the keys the pacman moves me the image. I have problems with the walls issue, I have the code so far Select Case KeyCode Case 37 '...
asked by 02.07.2017 / 06:45
1
answer

SAS or VBA excel sort data from left to right respecting column headers

I am trying to sort data as descending by row but to respect the names of the columns to show first the column with the highest value in the first month, and so on with all the lines of the month. I know that the first one prevails. It is what i...
asked by 15.06.2017 / 15:39
0
answers

COMBOBOX: Unidentified object error or variable with not established

I have a form that when starting must fill certain ComboBox, I have problems with some in particular, which are filled from a function that invokes data from SQL SERVER. The issue is that when I put the Call llenarInstrumentos(cmbCVinstr)...
asked by 30.06.2017 / 20:18
0
answers

Copy 2 rows once found a different value

I would like to copy the values from A to D: (2 rows of values per date) to another sheet For example copy the values A2: D2, A6: D6, A7: D7, A13: D13 .... I'm new to programming. I managed to find when the date changed, but then I g...
asked by 09.07.2017 / 11:57
0
answers

Extract data from Internet Explorer to Excel

Good day. I'm programming a macro that will extract information from a Table in Internet Explorer and upload it to an Excel sheet. So far I have only managed to extract the headers from the table but I have not managed to get the content....
asked by 12.04.2017 / 16:55
0
answers

How to activate the paragraph marks in Excel 2013 to visualize the end of the CRLF line in a * .csv file?

I need to activate the paragraph marks in Excel 2013, in word I already identify how to do it, adding this functionality to the ribbon. But in Excel I did not show the option Display (Display) to be able to activate the visualization. Could some...
asked by 04.10.2017 / 23:26
0
answers

Select a variable range in VBA

I have a table on an Excel sheet. I need to select and assign to a matrix a variable range that depends on two variables: Start Dia and DiaFinal . The first column of the table is a date field with this format: dd/mm/aaaa; This ta...
asked by 22.03.2017 / 14:01
1
answer

Error 3011 when exporting access data to excel

Good morning. I have a problem when I try to generate an excel from an access table (2010). I have the following code. Dim outputFileName As String Dim objExcel As Object 'New Excel.Application Dim objWB As Object 'Workbook 'Nombre del archivo...
asked by 06.02.2017 / 11:13
1
answer

Perform AutoFill or FillDown on a filtered column. Excel VBA

Good morning, The problem I have is the following. After making a filter with criteria other than N / A, I am placed in the first filtered cell to perform a VLOOKUP. This operation is performed perfectly, the problem is as soon as I want to d...
asked by 23.01.2017 / 14:32