Questions tagged as 'vba'

Tagged questions
1
answer

Access - Update on table without using VBA module

I need to update a table once a month, in which the inserted data should be placed in its current month. I have done this using VBA code, but since the table has approximately 30,000 lines, the process is time consuming. I would like to perform...
asked by 28.03.2018 / 20:09
1
answer

Does not find element with findElementById

Expensive, I'm trying to fill two text fields (login and password) of a particular page. Using the following code. (Both by byID, bySelector, none works) driver.findElementByName("usuario").SendKeys MyLoggin When debugging the code, when...
asked by 28.02.2018 / 16:46
1
answer

Select option select

Expensive, I'm trying to select an option on a select with the following code and I can not find a solution. I can find the element, but do not tell it to select X option. I'm locating with the following code: driver.findElementByXPat...
asked by 01.03.2018 / 23:14
1
answer

How to insert photos from a folder into a cell in Excel automatically? [closed]

I need to insert several images in Excel, but it is difficult to insert one by one, there are more than 300 photos, and there will be updates of these photos. I was wondering if there is a way to perform such a procedure?     
asked by 20.03.2018 / 22:50
1
answer

Delete certmgr certificate from the command prompt

I need to exclude certain certificates from my computer so they do not disturb my vba automation system, but I did not find anything that could give me a glimpse of how to do this by programming or by cmd line. I am currently using VBA to perfor...
asked by 02.02.2018 / 19:28
1
answer

How to count different names in a column in vba?

Good people, I have a question in a work in vba in which, in a column, there are four brands of cars: And the supposed is to put in cell c15 the mark that we want to look for and in cell d15 it has to appear the number of cars that there a...
asked by 28.12.2017 / 17:43
1
answer

Run-time error: 9 - subscript out of range 2

Hi! I'm having problems with this error. I believe that there is some problem in the data that I inserted, but I can not fix it. Calcul des cumuls annuels sur l'année hydrologique (1er septembre au 31 aout) For k = 1 To nbannees - 1...
asked by 21.12.2017 / 16:45
1
answer

VBA Print by PDFCreator

I'm trying to print an IE file through PDFCreator, in my searches I could not find a way in VBA to perform this process, until I found an algorithm that says to do this, but I could not solve a problem with WshNetwork, it gives me as Compile Err...
asked by 03.01.2018 / 13:57
2
answers

How do I change Image via VBA

Hello, I would like to change an image in Power Point, I do not want to delete and insert another , but rather do what the command indicated in the image does. Would anyone know how to call this method ???     
asked by 07.11.2017 / 12:52
1
answer

Resetting the counter every time you change lines

I have the following problem: I have two counters in my code, but I want every time I move to the next line, the contLine1 (second counter) is zeroed and start counting again, remembering that there are 32 columns when it comes back to 1 of the...
asked by 15.09.2017 / 20:01