Questions tagged as 'vba'

Tagged questions
1
answer

Goto Error Handling Does not work in loop

I have an application running in VBA, in it I have an error handling that works perfectly the first time the action goes through it, but it is inside a For Each loop and the second time it simply ignores the treatment, I do not know if I'm forge...
asked by 23.11.2017 / 14:05
1
answer

Copy columns of corresponding rows

I have a spreadsheet that contains 100 lines with country names and 12 columns (months of the year) containing values. My need is to compose a macro that: sweeps the columns and copies them to another worksheet so that the country stays in colum...
asked by 22.11.2017 / 17:00
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
0
answers

VBA - Copy and paste data without column sequence to rows

Hello! I have a spreadsheet with two tabs: In PLAN1 I have a single column with several data, but they do not follow a sequence. The values that can be found in this column are: Product code (Ex: AAA7X), A xxxx, B xxxx, C xxxx, D xxxx, E xxxx, F...
asked by 11.09.2017 / 21:13
1
answer

Macro Vba - IE ... Click, Not working button

I am not able to click on a button that generates a report in Excel (after it opens that "File Download" tab "Do you want to save? Open? Cancel ?, but this part is quiet, I think, if not me and if they already have the solution ...). Problem...
asked by 13.09.2017 / 15:31
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
0
answers

For Each In .Shapes GROUP control for excel [closed]

wave I would like to make a For Each In. Shapes "those shapes" but they grouped I managed to assemble with them ungrouped but grouped it looks like the procedures are different What I got so far, is a little incomplete because it messed up the...
asked by 17.08.2017 / 04:41