Questions tagged as 'vba'

Tagged questions
0
answers

call object with variable name excel vba

I want to make a block to call several buttons according to a variable. My idea (which is not correct) would be this: Private Sub Eliminar() num = Range("z1").Value ActiveSheet.Shapes("figura" & num).Select Selection.Delete...
asked by 13.11.2018 / 00:38
1
answer

MS Access VBA Value typed in txtbox1 should show values in txtbox2 and txtbox3

In MS Access 2016, the tbl01 has three fields: std_Id, stdnomb and std_nota. I have a form based on tbl01 and it has txtid, txtname and txtnota. I have been trying to write a code for the following: Al is To write a value in the txtid, the co...
asked by 12.11.2018 / 16:55
0
answers

Date conversion problem using Excel VBA

Hi, I'm doing a macro that changes a whole column that is dated dd.mm.yyyy to dd-mm-yyy, and I used the following command: Range("E:E).Select Selection.Replace What:=".", Replacement:="-", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase...
asked by 14.11.2018 / 20:16
1
answer

How to click on a web button that does not have id, class, tag, or name

The link page looks like the image, but I do not know how to call it from vba until the moment when it should do something like this used IE.document.getElementsByName("button")(0).Click But now I do not know what command to u...
asked by 14.11.2018 / 21:30
1
answer

VBA Access: Else is never taken into account

Initially I had the following code: Private Sub btn_Cambiar_Click() On Error Resume Next DoCmd.SetWarnings False Dim CambiarContraseña As String Dim coincidenContraseñas As Variant If coincidenContraseñas = DLookup("[Contra...
asked by 14.11.2018 / 17:14
0
answers

VBA Access - Error in product search engine

I am preparing a product search engine in a table. I want to know if there is a product unless it meets the given condition. If in the input of the function I put a 'c' I would like to know if there is at least one record that contains a text...
asked by 05.11.2018 / 16:02
1
answer

Problem with macro in outlook (vba) Not running

Good morning I'm doing a vba to outlook I found the following code and it worked, I began to add functions I need and everything was fine but I do not know what moved him that now the program (or macro) is no longer recognized by the outlook I a...
asked by 05.11.2018 / 18:09
0
answers

Error loading Userform (run time error 249 - crash Excel)

The detail is, I have a file that loads a form when it is opened, but if I close the form and then try to execute it again, it sends me the following error. "run time error 429 activex component can not create object" I already checked t...
asked by 31.10.2018 / 00:12
0
answers

How can I compare a txt with an excel and that this txt be traced line by line?

With a macro that I made I can perfectly pass a txt to excel from a route of choice. The problem arises that within the EOF function to get to the end of the txt I know only two instructions Line input and Input. Both read me line by line txt an...
asked by 25.10.2018 / 22:56
2
answers

Format of dates

This is a simple prototype of the function that I need because the problem arises with the Date object that takes the Weekday method as a parameter, as you can see, my function receives the values that you enter referenced by cells and in data t...
asked by 25.10.2018 / 23:59