Most voted "excel-vba" questions
VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. Use the Excel-Vba Tag when you have scripts problems of a Vbaproject in direct relation to the interface of Excel spreadsheets.
Learn more…335 questions
Sort by count of
-
0
votes1
answer249
viewsSearch the Dynamic Table with a macro
I’m trying to set a button to copy the value of a cell, paste it into one of the children of the dynamic table and give ok. Sub Botão17_Clique() ' ' Botão17_Clique Macro ' ' Range("H3").Select…
-
0
votes1
answer366
viewsExtract file . zip Password protected
I am doing a VBA macro in excel, to extract . zip files (which would be a barbada to do), except when the file is protected. I searched everything that is corner, there are several tutorials to…
-
0
votes1
answer63
viewsSort Worksheet by something by clicking on "explore"
Good Afternoon everyone, I am trying to filter a specific spreadsheet. The idea is to filter a spreadsheet by a subject. By clicking Explore. Example "Worksheet to be automatically filtered" I put…
-
0
votes0
answers264
viewsRuntime error '424' when running SQL
I’m trying to send data from excel to access through a macro. I edited on top of a ready and it seemed to me that I was doing the same thing, but it gives "Error at runtime 424 - the object is…
-
0
votes2
answers133
viewsUnify multiple worksheets from different workbooks
I have 800 Excel folders containing 1 sheet each, I need to unify these sheets into a single... I only need the columns A and B of each sheet and that it always paste the columns in the next free…
-
0
votes1
answer7301
viewsHow to break the line in a string in VBA?
I’m having a hard time putting a line break inside an automated email text by macro. I create the e-mail with the following Cód: "Necessitamos dos extratos do mês de " & Format((Month(Now) - 1),…
-
0
votes0
answers85
viewsVBA - Union of two non-adjacent ranges and transposed paste into another sheet
In order to minimize the number of selections for a spreadsheet in an iteration of 75000 records, I am trying to merge two non-adjacent ranges (2 separate columns, a total of 10 rows) in a…
-
0
votes0
answers57
viewsCopy some columns from the same row, from all worksheets to the start sheet (first) if it meets the criteria
I am doing a project where I need to find the variable in column Q of all worksheets valor procurado, and, if found this criterion, I need to copy the columns from L to Q of that row to the start…
-
0
votes1
answer613
viewsRuntime error '13': Incompatible types
I use a spreadsheet system in the service that we created at the time we used Windows 7. Then computers were upgraded to windows 10, due to the discontinuation of 7. It was created from excel from…
-
0
votes1
answer133
viewsI need to take a column with a lot of redundant information and just take one of them
I own a combo-box where I need him to go coluna "A" and take only one information of each (because it has redundancy of it), an example would be departamente in the case there is redundancy and not…
-
0
votes1
answer514
viewsRead special characters (such as accents and cedillas) in the html body
I am trying to read a news site, but the special characters (like accents and cedillas) are coming wrong. Example: In html code (and news site) is, for example: Examples 1: "Brazil prohibits people…
-
0
votes1
answer96
viewsvba creating tabs that exceed 31 characters - error
the data exceeds the character limits to name tabs in excel. How could I fix this? Sub compilação() linha = 1 linha_fim = Range("A1").End(xlDown).Row Range("B2:B" & linha_fim).Copy…
-
0
votes1
answer262
views -
0
votes1
answer1553
viewsHow to change with VBA the sender email and insert the signature for outlook email triggering?
I have to send a report where I need to insert a table in the body of the email, but I need to send another email (MBX) of the outlook and not of my staff, I’m not getting it, I tried with . from…
-
0
votes0
answers59
viewsVBA item comparison and amount additions
Personal hj I came to insert the image description here a doubt that will be very specific I do not know what problem of this code in vdd Xp I spent a few days breaking my head in it but I have not…
-
0
votes1
answer66
viewsListing in chronological order | Visual Basic
Good afternoon, how do I order the times chronologically without affecting the dates in excel, using Visual Basic? I have a spreadsheet where are saved the entries I do by VBA. In column G are the…
-
0
votes1
answer135
viewsHow to open a VBA website
Hello, I found a code that enters a website and makes authentication. After that it is on the home page of the site. I wanted to put this code to enter another link, but without closing the Internet…
-
0
votes1
answer36
views -
0
votes1
answer53
viewsMacro that compares value and returns the difference between them
I have a spreadsheet Home and another BD, in BD I have data of various types of cars (Name, Type (Sports, Casual), Color, Seats(2 or 5) and Price. And in Home I have 1 group of Buttons option, with…
-
0
votes0
answers14
viewsSearch listbox index from two inputs ofTextbox
Good afternoon, The goal is to find the index in the Listbox corresponding to two textbox values. Textbox1 looks for the value in column 0 and textbox2 in column 1. Both of these values in listbox…
-
0
votes0
answers63
viewsVBA Excel: "Incompatible Byref argument type" when passing Variant Array, from Sub / to Function
Claim: - Functions to calculate from an Array. Problem: - Error in 2.2. (below). Dice: Public Type varVar declares 2 variables Variant: varLatest ... last record of tables varAaD ... Function result…
excel-vbaasked 4 years ago Carlos Alexandre 1 -
0
votes0
answers19
viewsWhy don’t my vectors store the information in my textbox ? I’ve tried everything
Sub Email() Dim z, i, count As Integer Dim r(100000), s(100000), t(100000), u(100000), v(100000), w(100000) As String Dim a As String a = txtDataDOU.Value count = 0 For i = 1…
-
0
votes1
answer243
viewsHelp VBA create folders and subfolders and save file inside
Good morning guys, I need help with a code in Vba, basically what I want to do and in the directory that is the Excel workbook he creates a folder called "Save"And inside this Save folder he takes…
-
0
votes1
answer81
viewsRename multiple files with VBA
Good morning everyone. I adapted a code to rename several file with vba, which performs the following function: I select the folder, The VBA opens the PDF (Invoice) , extracts the information from…
-
0
votes2
answers40
viewsCompare the value of a cell with the name of a tab in VBA
I have the following problem: I have 2 tabs a so-called "List" where are the names of the employees and the position that each occupies, this list with names changes monthly, as an example Official…
-
0
votes1
answer138
viewsHow to identify the last row of a VBA formatted table
Personally I have a seemingly simple problem: I have to identify the first empty row of a table, but this table received a formatting of the excel itself "Format as tables". When I ask to identify…
-
0
votes0
answers27
viewsVBA Progamation to Enter Worksheet Password to Update Information
Great day, you guys! I have a spreadsheet matrix where pulls the information from four other spreadsheets. These four spreadsheets are password protected. I created a VBA code for when open the…
-
0
votes1
answer80
viewsInsert signature already made in macro VBA
I would just like to insert a signature made in Outlook itself with image and text in this VBA, but I do not know how. Follow the code: Sub Aplicacao_Fundo() Dim OutlookApp As Object, OutlookMail As…
-
0
votes1
answer154
viewsVBA excel perform action from dropdown selection
Talk people, good afternoon, all right? I came to ask for help from the university because I’ve been racking my brain for days and I can’t seem to solve my problem. I basically have this table: By…
-
0
votes1
answer27
viewsVBA - Redeem the value of a website variable
Good evening, everyone! I’m starting in VBA and I made a macro that returns the information of a pro Excel site, but I’m adjusting some things and I came across a problem a few days ago and I can’t…
-
0
votes1
answer26
viewsVBA - Copy and paste column to the new tab with the given code
Hello! I have a VBA code in the format below. It takes all the information from column B and sends it to another tab, whenever the value of B1 is changed (only does not create another, if you…
-
0
votes0
answers20
viewsAutomation of IE VBA drop-down list I need to select an option
Hello guys I am performing a process of automating a site, more when I arrive at an option, it opens others that I can not select. I am using this code "objIE.document.getElementById("img1.0_p").…
-
0
votes1
answer43
viewsHow to send dynamic image in the body of the email with VBA
I created a macro to send different images in the body of the email to different people. The problem is that I am not able to leave the dynamic image in the body of the email. It is attaching right,…
-
0
votes1
answer32
viewsINNER JOIN with SOMA - SQL
Good morning! I have two tables in access that present me CPF and value, but I am not able to join the two tables adding the amount. As I do not understand access, I am trying to make the query via…
-
0
votes1
answer28
viewsdata types inside the vba
I have a macro that does a conversion, it brings a fixed width txt converts to excel and saved in csv. what happens is that I need the last column to be saved in txto format because it deals with…
-
0
votes0
answers28
viewsVBA System User Input
Good afternoon, my friends. I arose a demand here in the company in which I do not understand much that would be in VBA I am sql programmer and went to learn a bit of vba to be able to automatically…
-
0
votes1
answer70
viewsHow to run a python script using VBA
I created a project that consists of sending automatic messages through the Telegram API, I did all this part in Python and works perfectly, as shown below. import requests from datetime import date…
-
0
votes0
answers19
viewsLoad table in Listview
I’m trying to load a table into listview but when I press the button it gives me a mistake saying that the Required object(error 424). Private Sub btnPesquisar_Click() With txtResult1 .Gridlines =…
-
0
votes0
answers43
viewsCheck Box(Form) - Copy to row below and change cell link
Hello! I would like to know if it is possible to carry out the following: I have several checkboxes, where each one is linked to the cell in which it is, when selecting the cell of this box and…
-
0
votes0
answers9
viewsHow to Save File Inside Folder(Variable Name) Excel VBA?
am having trouble saving workbook in created directory Code to create folder Sub CRIARPASTA() Dim VAR As Object, NOVAPASTA Dim Nome As String Dim OS As String Nome = Worksheets(3).Range("f5").Value…
-
0
votes0
answers12
viewsError VBA Sellenium - Webscrapping [Nosuchelementerror - Element not found for Xpath]
Hi, guys! I really need your help on this one: I’m trying to make a webscrapping on a phone company’s network interruption page. For this I am using Sellenium Webdriver + VBA to do this. However,…
-
-1
votes1
answer439
viewsExcel change only part of a cell text
In an excel document I want a certain text of a cell to be automatically enumerated when I copy the entire group of cells. Example of the explanation. - What I want is to copy the whole text and…
-
-1
votes2
answers2874
viewsSeparate fixed headphones from furniture to add ninth digit
I have a spreadsheet with almost 60 thousand lines, with 3 columns: Name | Phone 1 | Phone 2 In the two speaker phones I have fixed and mobile phone numbers and for me the logic is simple: Fixed…
-
-1
votes2
answers902
viewsExcel form (Block fields)
I have a question about what formula I can use. I have a box with 3 options (Example: 1 , 2 , 3) and if I select the option 1 I can fill in the field 1 and are blocked options 2 and 3. If you select…
-
-1
votes1
answer282
viewsHow to make a VBA print
I have an excel full of information But I want to separate the information Imagining that I have in a cell A-ABC-DEF How do I get ABC to appear through a formula in VBA
-
-1
votes1
answer924
viewsVBA to fill empty cell
good morning, I have a spreadsheet in excel that I would like when I impute a date and press the macro button to paste into the next empty cell in column A, 74 times. And also copy two columns (B:C)…
-
-1
votes1
answer805
viewsVBA Calling program in Python
Hello, I work for some time developing in VBA. but I’m beginning to learn Python and the following Doubt has arisen ... is it possible to unite these languages ? because I did not find anything in…
-
-1
votes1
answer175
viewsHow can I open Postman by excel vba?
I wonder how I can open the POSTMAN by the EXCEL VBA. I would like to instantiate the application as an object but I do not know how to do. Example: Set IE =…
-
-1
votes1
answer227
viewsThe file is locked - Excel and VBA
I have an excel spreadsheet with userform to control a database that is also in excel, this database for having many accesses is shared, but today I saw that VBA does not get along very well with…
-
-1
votes1
answer368
viewsExtract a text from a <td> with Selenium + VBA
I am trying to extract the 'PRESI-VALEC' value from this element in Selenium, I thought to use Xpath as follows: .Findelementbyxpath("//a[contains(text(), 'PRESI-VALEC')]/table/tbody/tr[2]/td[3]"),…