Questions tagged as 'vba'

2
answers

VBA / Excel Combobox: Disable Auto-Complete

I am typing a text that is in a ComboBox of VBA / Excel , but the initial part of the text matches another text already included in the list, which I do not want), it changes the position of the list (the index). Can you handle this? When...
asked by 24.11.2015 / 22:27
1
answer

VBA Macro fetch information on site

I need to search for information on a real estate site and bring it to excel. I made the macro below: Sub zap() Set ie = CreateObject("InternetExplorer.Application") With ie .Navigate "http://www.zap.com.br/imoveis/fipe-zap/" .Visible = True...
asked by 06.03.2014 / 18:29
3
answers

Run VBA code from text file

I have a code in VBA that makes a query to the database and saves it to a text file, but to execute this script I have to open Excel and execute macro , this process has to be done minute in a minute because I need informatio...
asked by 02.04.2014 / 03:31
1
answer

What are the main differences between VB.NET, VB6 and VBA?

What are the main differences between VB.NET, VB6 and VBA?     
asked by 18.09.2016 / 22:59
1
answer

How to generate a full value in Portuguese in MS Office Excel?

In an Excel spreadsheet, having a cell with a numeric value, how to calculate its value in words? For example, in cell A1 I have the value R$ 587,32 . I need a function that passed the cell as a parameter, return the text:...
asked by 14.12.2013 / 16:35
1
answer

VBA - SQL - Filter with SELECT

I would like help with extracting information from another worksheet through SQL. The link on the worksheet where you will establish the connection and extract the information is this: Google Drive The link to the spreadsheet where the D...
asked by 17.11.2018 / 23:00
2
answers

Failed to connect to MySQL via VBA

I'm trying to connect to a Mysql database via Excel VBA, but it returns an error reporting catastrophic failure. I did a test by entering the wrong password, or the wrong database name, and it informs that access was denied or the database does...
asked by 12.12.2014 / 12:50
3
answers

How to make a standalone script using Global.asa

I want to run a script that writes information to the database every 24 hours. I am not the administrator of the server, so I do not have access to Scheduled Tasks , I read in some articles that I can use Global.asa for every time t...
asked by 28.05.2015 / 14:43
1
answer

VBA - Backpack problem

In excel I have the following table | Produtos | Preço | | Produto A | 100 | | Produto B | 250 | | Produto C | 200 | | Produto D | 800 | | Produto E | 560 | | Produto F | 970 | ... And I would like to make all possible combina...
asked by 05.02.2014 / 18:49
1
answer

How to dynamically create events in VBA?

The code below creates Labels dynamically and now I need to control the mouse action (Click event) on each Label. For example, move the text font (Caption) to bold if you are regular (not blacked out). How to create the "Click" even...
asked by 24.05.2016 / 18:04