Most voted "vba" questions
Visual Basic for Applications (VBA) is an event-oriented programming language with limited object support, used to write macros, available for the entire Office suite.
Learn more…792 questions
Sort by count of
-
0
votes1
answer194
viewsMacro VBA to organize records in employee point report
I need to organize the data that’s in chronological order for a report that’s in date. Macro must first iterate through the CRM column, then through the DATA column and organize the same date…
-
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
answer42
viewsAdd exception in Cell.Delete
I was using this Sub Clearcontents to clean up all the content I had in the Sheets, I need to add an exception that is the G1 cell and I found this other Sub, but I don’t know how to mix the two Sub…
-
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
votes1
answer314
viewsSelenium VBA to insert text into an ID
My code tries to copy from the windows Clipboard and paste into the site ID with VBA + Selenium. Option Explicit Public Sub PasteInfo() Dim d As WebDriver, clipboard As Object, data As String Set d…
-
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
answer322
viewsClickcontext and copy
Good morning. My code is like this Sub pegadadoschrome() Dim obj As New webdriver Dim keys As selenium.keys Set keys = New selenium.keys obj.Start "chrome", "" obj.get "https://gvt.etadirect.com/"…
-
0
votes0
answers321
viewsVBA running python - Script does nothing
Good afternoon, I have a VBA command calling a specific Python script. What happens is that if I run the script manually, it works perfectly, no problem at all. Running by VBA it only gives the…
-
0
votes2
answers184
viewsDifficulty to loop in VBA
I made a code Visual Basics to identify the maturity of insurance policies and raise a pop-up and fire an email alerting you if you are close to maturity. The database is displaying the Policy…
-
0
votes2
answers127
viewsDifficulty in identifying min value and sending selected Cells by email. VBA
I’m trying to do a macro where I can identify if there’s a due date in the column L which expires within a month, and if any, launch a msgbox and send an e-mail via Outlook pasting the entire table…
-
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
answer57
viewsVB Visual Studio Cells error
First of all, thank you for your help. I’m new to code and I couldn’t get an answer to these questions even with searching on the net. I am trying to develop a code in the visual studio in Vb.net…
-
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
answer111
viewsAccess menu mouseover by VBA
I need your help! I am developing a VBA application to extract files from an internal system of the company, where after logged in to the site, the displayed screen has a menubar for access to…
-
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
answer163
viewsHow do you know which worksheet line the selected listview item is on?
I filled my Listview and applied a filter, so that the user can choose the values to be observed. However, I need that the user can add information to the selected item and that these values are…
-
0
votes2
answers684
viewsSave Path Name and Worksheet Name to a Cell
Good afternoon, Guys, I need a function in VBA that I can select a file and write the file name and its path in two cells. The file path I got, according to the code below. But the file name no, can…
-
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
votes1
answer235
viewsUser name with open Excel file - VBA
Objectively: How is it possible to know, with VBA, which name of the user has an excel file opened, that file is somewhere on a server and not on the local disk? Context I have searched for a…
-
0
votes1
answer30
viewsDoubt last line in VBA
Hello, I’m writing the following code. Sub DINAMICO() Dim LINHA As Byte, PREENCHIMENTO As String, PREENCHIMENTOTWO As Currency, PREENCHIMENTOTRES As String *Range("A1") = "PRODUTO" Range("B1") =…
-
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
answer64
viewsExecution Error 424 - Import multiple XML files in VBA
I’m completely new in vba and I’m having a problem with my code. I need to extract data from some tags from various files XML. When I execute the code or perform Debub, the error of 424 "The object…
-
0
votes1
answer67
viewsVBA interaction with Internet Explorer and use of getelementsbyclassname does not work
I’ve been trying to create a code that makes me log into Internet Explorer(ie), go to yahoo’s website, add my stock search and search, but the search part won’t go. This is my code: linha_ticker = 2…
vbaasked 4 years, 2 months ago Adriano Camargos 1 -
0
votes1
answer48
viewsI need to insert photos automatically in a spreadsheet in Excel but my VBA code does not work the way I want
Well, I looked for a solution to my problem, (for many photos at once and organized in the spreadsheet) on Youtube, forums and etc., but the nearest solution was this one, which originally filled by…
-
0
votes1
answer59
viewsI’m starting in VBA, can you help me?
I need to make a code that when I click on a button (in the "MARC" spreadsheet), it copies the information in the row (which would be a variable) and columns A through G, and leads to another…
-
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
answers45
viewsImport some columns from TXT to VBA
Good afternoon! I’m quite a beginner and I’m having doubts about how to proceed. I have a TXT and could import it to VBA and until I could get the first line that I didn’t need. However, I need to…
-
0
votes1
answer85
viewsVBA does not show the options and Methods automatically
I’m new here, and I apologize for the "banal" doubt, but I’ve been researching this for a long time. I use the VBA by EXCEL, and I can’t activate the option of the text if self-prefill when writing…
vbaasked 4 years ago Anderson Gama 11 -
0
votes0
answers76
viewsI have an automation error in excel VBA
My code gives an error and closes Excel for no reason. Follows the photo and the code Sub inserir() Dim tabela As ListObject Dim n As Integer, id As Integer Set tabela = Planilha1.ListObjects(1)…
-
0
votes1
answer112
viewsAdd items to listbox
Good afternoon, you guys It’s a very stupid question, because I’m starting in vba programming and I’m not being able to correct this error. I’d appreciate it if someone could help me I would like to…
-
0
votes0
answers87
viewsRuntime error "5852"
I used this code to generate a direct mail and separate the files. But the following mistake is being made: Runtime error "5852" The requested object is not available. Use of office 365 Sub…
-
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
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
votes0
answers39
viewsVBA word - Create multiple bookmarks from search results
I am assembling a code that searches 'words' from a list and from the results: creates bookmarks for each result hyperlink to the bookmarks The search part is working, but the bookmark creation part…
-
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
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
answer42
viewsRepeat image for lines below - MACRO
The VBA formula to insert pictures in the spreadsheet works, however I need to repeat the same code for lines below, however the image is deleted from the previous line, appearing only in the line…
-
0
votes1
answer339
viewsClick on the link with vba
I need to click on the object that has the hyperlink to continue browsing the page. Error occurs on line: ie.document.getElementsByTagName("td")(0).CLICK. Sub busca_desc()…
-
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
votes1
answer31
viewsRefreshall crashes VBA execution
Hi, I looked, but I couldn’t find anything similar to my problem. I work in a company where we have some reports, in a remote terminal, which have queries to databases, after the query always…
-
0
votes1
answer119
viewsHow to access menu mouseover with VBA
Good afternoon! I’m trying to automate the filling of a form for a website, however, I’m having difficulty entering the menu where the form is. It works like this: I login to the site through a…