Questions tagged as 'excel'

Tagged questions
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
1
answer

excel macro enter key

I try to make a macro run by pressing Enter . The idea is that when you press the Enter key, create a new row with a auto-numeric value. The problem is that when recording the macro, it takes the ranks . Is there any way for the macro...
asked by 23.05.2018 / 16:00
1
answer

Error 13 in macro: the types do not match

When creating the next macro to copy, from one sheet to another only the cells that meet the condition, the execution shows me this error:    "error '13': the types do not match" Code: Sub CondicionalTopTxx() Dim OrigenHoja As Excel.Wo...
asked by 10.05.2018 / 11:47
1
answer

Bring data that depends on two columns

I have the following information: _____A___ _|______B_______|_______C_____ 1 | CODIGO | CONCEPTO | VALOR 2 | 111222 | con1 | 12000 3 | 111222 | con2 | 11000 4 | 111222 | con3 | 5000 5...
asked by 26.04.2018 / 01:14
1
answer

VBA Get text fragment of an html element with id

I am trying to access a web page with a macro in Excel, enter a code in an input, press a button and copy the price resulting from the search. It is this last step that I do not achieve. The element that contains the price has the id #result_ok...
asked by 06.05.2018 / 22:36
1
answer

How to delete the first records of an excel in c #?

I am trying to load the data from an excel to datagridview, and this is my result of the load. my question is how to eliminate those Column1, Column2, Column3 .. etc .. and that my result is the same as product id, unit of measure, key,...
asked by 02.05.2018 / 18:34
1
answer

Export to excel in Symfony 1.4

I'm working with Symfony 1.4 and I have a problem. Following a query, a view is generated that shows the data of a person and their cars. This data I want to export to excel. It works well for me, except that, if that person has more than one ca...
asked by 12.04.2018 / 22:00
1
answer

Formula to extract more than one data from the same client

formula to collect more than one data from the same client, and this is placed in the first name found of the client, (it is worth mentioning that the base is arranged in alphabetical order) the base is as follows: ID nombr...
asked by 14.03.2018 / 19:59
1
answer

Problem format when getting the name of an excell sheet in VBA

As ridiculous as it seems I have a problem when it comes to getting the name of a Excel sheet because it is written to me in date format. The sheet has name JUL02 and I want to get exactly the literal "JUL02", however, when reading the name...
asked by 02.04.2018 / 14:13
2
answers

Search if an hour is in a pool of hours [closed]

How can I know if one hour is within a range of other hours? I put the image For example, E2 should return an Inside if B2 is in the range of C2: D2, C3: D3, E4: C4 etc. or an Outside if it does not meet the condition. I tried this code...
asked by 24.01.2018 / 18:37