Questions tagged as 'vba'

Tagged questions
1
answer

VBA - Popular array string and no repeat values

I have an Excel WorkBook x. This WorkBook has 3 spreadsheets. The 1st is still empty; the 2nd is Birds and we have repeated values and the 3rd is Mammals also with repeated values. How do you populate a string array with the values of Birds a...
asked by 21.03.2018 / 06:10
1
answer

VBA code to delete line

Well, I have a code that checks the line if there is a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp But in the spreadsheet there are phrases like "Defect + broadband" or...
asked by 07.05.2018 / 21:12
1
answer

VBA - Error: The 'frames' method of the 'JScriptTypeInfo' object failed

I need to fill in the box on the 'Legislation' tab with the text 'Energy Development Account' and do the research. But when executing the code it appears the error mentioned in the title referring to the line "obj = IE.doc [...]". 'Declara fun...
asked by 26.03.2018 / 21:01
1
answer

Remove duplicate names by VBA approach [closed]

Good afternoon! Is there any code to find / remove dupli- cations by approximation? I'm trying to clean a very large base, however the names that have been entered have typos or letters with the same phonetics. For example: Luiz Carlos Sil...
asked by 19.01.2018 / 21:47
1
answer

How to rename a folder added to the current date to the name

I have a folder where I keep data that needs to be updated daily. In order not to lose the history I copy this folder and paste it in another place. But after copying and pasting the folder, I need to rename it with the current date so I do not...
asked by 23.03.2018 / 14:59
1
answer

IF Condition - Display or Hide TextBox

Expensive, I have 4 optionButton (2 different groups), where 2 represent "Yes" and "No" for two different questions. What I want to do: When the user chooses the NO option in group1 and then chooses the YES option in group2, a textbox i...
asked by 06.11.2017 / 11:01
2
answers

Get tab names in a closed spreadsheet

Hello, I have a master list of documents that updates itself, it does not open any files, it only uses the reference to find the data, but it happens that some of the employees are changing the name of the tab, this causes to update the workshee...
asked by 10.10.2017 / 16:01
3
answers

How to add character after the last word written on the line

Dear Community, I have a doubt that I have tried everything, but I can not solve it. I have a list of ex names; José Mario da Silva Mariana Cristina William Caio Jorge Luiz Campos de Silva Andrade In case there are more than 2,000 nam...
asked by 29.09.2017 / 18:05
2
answers

How to read a single row txt file in VBA?

I would like to read a txt file through VBA. All the codes I found on the internet loop in the file (to get all the lines I suppose), but I wanted to just get the first line in a simpler way and put it in a variable. Here is my current cod...
asked by 14.09.2017 / 00:24
1
answer

VBA Rename all files that begin with "Rel"

Hello I need to generate a code that renames all files in a folder that start with "report" to "X-CT". The remainder of the filename, including the ".DOC .PDF. XLS" filing continued unchanged.     
asked by 28.06.2017 / 22:42