Questions tagged as 'excel-vba'

Tagged questions
1
answer

Excel VBA - Check file size and type

In my worksheet I have a button that displays the file selection box. After selecting an image, it is displayed in a specific cell. How do I check if the chosen file is really an image? and How to limit the size of this image (for example...
asked by 04.12.2017 / 13:54
1
answer

How to do a Dowload in IE via VBA?

Hello, I'm using the following code to start a dowload in Intenet Explorer. Public Sub Dashboard() Dim Navegador As InternetExplorer Dim objShellWindows As New SHDocVw.ShellWindows Dim currentWindow As HTMLWindowProxy D...
asked by 06.10.2017 / 19:40
2
answers

Loop to Repeat Names

Dear Community, I think the solution is simple, but I'm trying to do the following business rule: I have a list of names in a Plan1, I need the name of each of them to be repeated by 12x each in Plan2, I have a code that can repeat the fir...
asked by 06.09.2017 / 19:18
1
answer

Compare two columns in EXCEL and if they are equal return a certain value

I'm having trouble generating a logical structure (If) to validate some data. It's for a search. follows the explanation: There are two columns ( B and H ). In the B column there are all Brazilian municipalities and in column H there ar...
asked by 04.09.2017 / 01:39
2
answers

Problem with macro that performs dynamic sums and noncontinuous intervals

I have a worksheet where column A has following values values (1,2,4,6,8,10), the fields with value 1 must be the sum of all groups 2 below it until the next value with field 1, and group 2 should be the sum of all values from group 4 below it t...
asked by 26.07.2017 / 16:41
2
answers

Automatically fill cells in excel using VBA

Good afternoon community, I am trying to work with VBA in Excel to try to apply this knowledge in my master's thesis, but I have some questions. I'm trying to create a function in VBA that populates cells by a given value. In the next imag...
asked by 13.07.2017 / 19:41
1
answer

How to look up a column by value = 200 (execute command)?

I want to search the line within the P:P column for a number less than or equal to 200 and run a command. If it is greater than 200 perform another. The values are thus defined 0.0 . If .Value =< 200 Then ActiveCell.FormulaR1C...
asked by 02.06.2017 / 16:40
2
answers

How to assign the formula of cell D2 in a variable?

CODE: Range("AB2").Select Dim tudo As String data_pasta = Format(Date, "/yy/mm/") tudo = "https://pagina.pt/wp-content/imagens" & data_pasta & **D2** ".png" ActiveCell.Value = tudo ultima_linha = Range("A" & Rows.Count).End(xlU...
asked by 31.05.2017 / 17:36
1
answer

How to execute a VBA command on a sheet with a specific name?

I have an Excel document with multiple sheets. In this document I need to execute a command on a specific sheet, ie the sheet name. But if this sheet does not exist run another command on another specific named sheet until the sheets are finishe...
asked by 25.05.2017 / 22:41
2
answers

RANGE class SELECT method failed

The intention is that when you click on the Euro Synths tab, the macro impute the "L" character in cell D1 of the Local Synthesis tab and then return to the Euro Overview tab. I was able to solve the error problem by allocating the macro in the...
asked by 24.07.2018 / 15:55