Questions tagged as 'vba'

Tagged questions
1
answer

Error 1004 in a macro

I created the following macro: Sub Extraer1() 'Definir origen y destino que utilizaremos Dim OrigenHoja As Excel.Worksheet, _ DestinoHoja As Excel.Worksheet, _ OrigenCelda As Excel.Range, _ DestinoCelda As Excel.Range 'Definir las...
asked by 08.05.2018 / 12:27
0
answers

error 53 when executing shell

In an Access form I have a button that I want it to execute: Shell ("c: \ Windows \ system32 \ osk.exe"). The bbdd runs on a touchscreen laptop so that when you click on the button the shell is run and the Windows screen keyboard appears in o...
asked by 03.05.2018 / 13:16
0
answers

remove duplicates from an excel sheet

I have numerical data on sheet 2 and what I need is to eliminate the duplicate data, keeping the first data and eliminating the remaining data and the remaining ones sorting them in sheet 3 according to image I have this code to delet...
asked by 20.04.2018 / 16:50
0
answers

Reference to HtmlElementCollection in Excel 2016

Good morning. The issue is that I need to use a WebBrowser in an Excel macro, but when I use the variabe type HtmlElementCollection says "the user-defined type has not been defined". I know that I should refer to the library of the class to w...
asked by 17.04.2018 / 22:44
0
answers

how do I make this userform comply with these conditions in vba

I have this code of the form that according to the data that is placed in the columns "ba: bd" of all the sheets, analyzes them and looks for a repeated number among the four sheets but the detail is that if the number is repeated more than once...
asked by 11.04.2018 / 17:31
1
answer

Reload browser html content in vba

I have a code in vba that opens a page of ie. I get the html and then I pulse a bonton that is in a popup. That button adds new code to the html of the page, so when added later, I can not access to press another popup button. I need to reload t...
asked by 09.04.2018 / 16:03
0
answers

sql query from a table in an excel file

My query is: on how to insert texts from a table in an excel file, to textboxes (vba form) using an sql query. this is the code: Private Sub cmdBuscar_Click() On Error Resume Next Const adOpenStatic = 3 Const adLockOptimistic = 3 Const...
asked by 05.04.2018 / 20:42
1
answer

Error 91-With not established

Why is this error in the code? Dim FSO, folder, subFlds, fld, ParentFolder, path Dim oFSO As Object Set oFSO = CreateObject("Scripting.FileSystemObject") ParentFolder = oFSO.GetFile(ActiveWorkbook.FullName).ParentFolder.ParentFolder.pat...
asked by 02.05.2018 / 17:32
0
answers

How to update a view (Data sheet as subform), extracting data from a query of it In VBA ACCESS

I have the following code, the data sheet of the subform is the same that I have in my main form, it is supposed that only a Requery is required but it does not update me, it tells me that one of the fields is out of range: Private Sub cmd...
asked by 28.03.2018 / 00:35
0
answers

Force Visual Studio Ultimate to delete a file in use

I am trying to write a program in Visual Basic that will erase a file in use. The code below can erase images, music and videos in use but you can not delete documents. Is there any way to make the program detect the process and stop it so yo...
asked by 25.03.2018 / 17:17