Questions tagged as 'excel-vba'

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

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

VBA - Paste Reports on the determined Sheet

I am assembling a macro that opens a specific report that copies the data, and then pastes it into another worksheet on a particular sheet . But I'm having a hard time sticking to the other spreadsheet. So far we have: Dim as Integer Data=...
asked by 21.06.2017 / 16:54
2
answers

Excel VBA delete item from ListBox

I'm having trouble deleting an item from a listbox . The code works like this: it will have listbox with the list, and when the user wants to delete an item, it clicks a button that opens another userform , in that userform...
asked by 03.05.2017 / 16:30
1
answer

Copy and Paste Special with VBA

I have a VBA script that copies a column (from an Excel spreadsheet) with formulas and glues only the result (Paste Special). But I would like to automate this task, for example: Whenever you add some information in the "A" column, the data...
asked by 27.12.2018 / 14:30
0
answers

ssh command is not recognized in shell when called by Run command via vba

I am mounting a macro that accesses the ec2 instance of AWS Amazon to run a python file. When I give the command at the Windows prompt, opening by run / cmd, the command below works. However, when I open Shell by the Run command, it says:   ...
asked by 20.12.2018 / 12:34
0
answers

How to extract data from the internet by VBA

I'm trying to extract a specific table from a site and paste it into a worksheet to update a database on a daily basis. But as it is impossible to download the table as excel or csv, I should extract the table directly from the site....
asked by 03.01.2019 / 14:40
0
answers

Select a different domain in the outlook box (not another specific email) to send an email from an excel file

What is the VBA code that I should use to select an email from a different Outlook account from an Excel? That is, I need to configure for a team of 30 people that the excel file I created recognizes the email they use to talk to clients, not...
asked by 06.12.2018 / 13:16