Questions tagged as 'vba'

Tagged questions
1
answer

Highlight TextBox if the value loaded is the same in the worksheet

In a registration form when clicking search the textbox are filled. And if any of those TextBoxes has a value that appears in plan1 from the "AS" column then that TextBox has the highlighted text (eg Green). I got a code but it is not working....
asked by 28.06.2016 / 19:23
1
answer

Open another instance of Excel while VBA runs

I created an application in Excel that extracts information from the internet, directly to it through the Selenium IDE Webdriver. However, while this application runs, I can not open a new worksheet, or a new instance of that macro, is there a p...
asked by 20.01.2017 / 19:39
1
answer

Handling internet explorer using VBA

In the footer of this site " link " has an icon that downloads a file .xls. I needed to click on it and save the file, but I do not know how to do it. The code, adapted from another one provided by danieltakeshi, of the two forms I tried to m...
asked by 20.03.2018 / 14:34
1
answer

VBA. I try to convert a txt to excel

I have this macro to convert several txt to excel , but when converting it does not separate the file by column ";" Sub Convert_Csv() Dim File_Names As Variant Dim File_count As Integer Dim Active_File_Name As String D...
asked by 15.07.2016 / 23:08
1
answer

VBA - InterneExplorer Object (Frame)

I need to access a TAG (a) that is inside an Iframe that loads on the same page after a submit. See how strange: When I load the object in VBA code, I see the Iframe that I need, but the HTML inside the Iframe is not loaded into the VBA c...
asked by 15.02.2016 / 00:56
1
answer

VBA returns wrong date string

I made a code to return a string from the first day of the month acts: Dia = "1/" & CStr(Month(Now)) & "/" & CStr(Year(Now)) Then I put it in a cell Cells(rowx,colx).value = Dia The pasted value change position the day with...
asked by 02.02.2016 / 21:15
1
answer

Allow automatic sending of emails with Outlook

Hi, I need to send multiple emails to different addresses automatically, but when VBA starts the send process it opens an alert box asking for my permission to complete the task. Does anyone know how to override this alert and send the...
asked by 28.04.2015 / 19:20
1
answer

How to import mysql data with VBA without unconfiguring the text

I have a macro that connects to mysql and executes a query that is in a text file and adds the records to an excel sheet. It occurs that the text comes unconfigured. Example: Correct: CALL QTDE MADE (CPF VISION) How It Comes: CALL QTDE HELD (VIS...
asked by 18.03.2015 / 20:58
1
answer

ADO Command / Parameter in Excel (VBA)

Hello, I'm developing a code in VBA in Excel 2010 in conjunction with an Access 2010 bank. In this code, I use ADO Command to manipulate the data in the database, however I am getting an error message in a particular piece of code. The...
asked by 06.04.2015 / 21:29
1
answer

Choose a file in a folder and save it as text automatically

I want to make a VBA code that opens a specific spreadsheet and saves it as tabbed text. I'm having this formulated code Sub gerararquivotxt() Dim intChoice As Integer Dim strPath As string 'permitir escolher só um arquivo Application.FileD...
asked by 17.11.2014 / 19:29