Questions tagged as 'excel-vba'

Tagged questions
1
answer

Copy Cells When Identifying Change Worksheet_Change (Excel VB)

I am new to VB and am trying to get an operation that copies some information from the "Client Backup Control" worksheet to the "LOG" worksheet. The process will look like this: When detecting change in any cell in column N of the "Client Backup...
asked by 07.06.2018 / 19:25
1
answer

Error '70': Permission Denied

When I run the code below, the title error appears in the 'For Each' line. Is this a block from the site itself or does it have some error in the code? Declara função Sleep If VBA7 Then Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVa...
asked by 29.03.2018 / 14:41
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 - 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

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

Edit data from a DropDown List in Excel

I have a list of items in a dropdown in excel. These values must be selected by the user and from there, edit them as requested. However, I do not know how to edit these dropdown values. Can someone help me? Below is an example of two items that...
asked by 01.12.2017 / 12:01
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
0
answers

Recursive errors generating a word file from the fields of an Excel worksheet (VBA)

Good afternoon, I never programmed in VBA but I found myself in a need where I need to generate a word document from some cells of a worksheet in excel, after searching several websites on the internet I was able to make a script that works, the...
asked by 28.11.2018 / 17:28