Questions tagged as 'macro'

Tagged questions
1
answer

VBA macro for automatically inserting images based on a code column

Good afternoon, I have a spreadsheet, which has a column with the code of the photos and the other column next to it with spaces to insert the images. I would like to know if there is any way to elaborate a macro, in which it recognizes the c...
asked by 30.03.2017 / 18:58
1
answer

Consolidate macros

I need to create a macro that allows me to choose all .xml files and import them into excel. At this point the process is as follows: - I open the first one manually and then call the macro that imports all the others selected. I would like to k...
asked by 26.08.2016 / 21:46
1
answer

How to delete / delete repeated lines comparing different cells?

I want to know how to delete a line that is repeated throughout my table. The image below may help Possible solutions: 1. Scroll through the Macro of file Excel1 to pass the data to the file Excel2 . Avoid insertin...
asked by 04.03.2016 / 16:30
3
answers

Range in Excel VBA

I have the following code snippet: ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Users\Contoso\Desktop\ArquivosDoContoso.csv", Destination:=Range _ ("$A$1")) In the Destination:=Range _ ("$A$1")) part, how do I put the...
asked by 15.04.2015 / 13:38
1
answer

How to use the scan for a numeric variable [SAS]

I have a table like this: List_ID 1 4 7 10 (In total there are 100 numbers) I want to call them for a macro I've created. I was trying to do it with Scan, but I read that it was only for text variables. It gave me that my variables were...
asked by 11.07.2015 / 02:00
1
answer

Problem with macro

I'm trying to solve the following exercise:    Type a program that defines and uses the PRINTARRAY macro to print   an array of integers. The macro should receive the array and the number of   elements in array as argument What I've done...
asked by 22.10.2018 / 00:59
1
answer

Close Excel after running vba Macro in Qlikview

Macro set obj = ActiveDocument.GetSheetObject("CH1") obj.Export "caminho_para_salvar_arquivo" And now I need to close Excel, I used the following command. obj.Close caminho_para_salvar_arquivo' And I get the error Wrong number of arg...
asked by 15.10.2018 / 22:34
2
answers

MACRO to insert image in relation to the drop-down list

Good morning, I have a question that I do not know if it is light or not: I have a field (the large rectangle) of which I want to insert an image into it, depending on the drop-down list selected. For example: When I select in the drop-...
asked by 23.11.2018 / 11:43
2
answers

VBA Hour / employee control

I've been trying to learn the commands in VBA for a few days to automate a company employee's time tracking worksheet. I have a sheet with employee names and a calendar as follows: horas Local Projeto horas L...
asked by 10.03.2015 / 02:20
1
answer

Macro to delete filtered table row

I created a table with data from an account balance and I am making a macro to select only a few values. A macro assignment would filter all zeroed values into one of the columns to exclude the rows of those accounts that had no movement. Aft...
asked by 21.08.2015 / 23:26