Questions tagged as 'vba'

Tagged questions
1
answer

Save an image pasted to Excel worksheet through VBA

The code below copies a range of cells from a spreadsheet that is pasted to another worksheet, but I have not found a way to save it as an image file to a folder, or even select it to work with it image by VBA. Range("D19:H25").Select Applica...
asked by 01.02.2016 / 23:45
1
answer

Problem with VBA integration and Internet Explorer

I'm trying to use VBA to collect data directly from the internet. I have seen several examples of using the InternetExplorer Object, as below: Dim IE as Object Set IE = New InternetExplorer IE.navigate "http://www.minhapagina.com.br" html =...
asked by 29.07.2015 / 00:50
2
answers

Do not modify cell for given result. (History)

In a management table I have two columns one Status(Coluna A) and another Estado Anterior status . In this I want to save the same value as in column A, except for some cases. So it saves a history of status when it is concluído...
asked by 07.05.2016 / 16:18
1
answer

Macro to copy from one worksheet and paste only into visible cells from another

I need to copy the "L" column of the "DIVISION" worksheet to the filtered cells of the "L" column of the "DPTO" worksheet. That is, I need a macro that searches the information in a worksheet and pasts only the visible cells of the other. I w...
asked by 09.07.2015 / 15:32
3
answers

Make a copy of a filtered worksheet in excel vba

I'm having a problem, I need to extract a data listing from excel that I've filtered with over 200 thousand lines, I have the option to do the excel parse every line and delete it but I wanted to do this without losing the Given already present...
asked by 13.03.2015 / 13:49
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
2
answers

VBA to search for folders and concatenate file names

I need to evolve the following code to concatenate data in a certain way. I have a folder with product pictures (several photos for each product) and I want Excel to search the name of the photos and write the names of the photos related to each...
asked by 09.02.2015 / 09:31
1
answer

DELETE command in VBA does not work

I have a project that adds and deletes dates, to add I have the following code: Set dbs = CurrentDb dbs.Execute " INSERT INTO TMP " _ & "(diaMes) VALUES( " _ & "'" & tmp7 & "') " where tmp7 is the date in dd-mm-...
asked by 08.10.2014 / 13:41
1
answer

Filtering Power Pivot Table by ListBox

This code: link Make the selection in the ListBox ... and Filter driven by a button .. as described in the link ... But if the PivotTable is created by Power Pivot .. This code does not apply ... You can do this same job in this creat...
asked by 07.08.2018 / 21:47
1
answer

Excel: load list of names according to the selection of another list

At school I work with a file with class worksheets (the name of the worksheet is the class number, eg 100, 200, ...). I need to make a spreadsheet in this file to generate Declarations, where I need to select the Class, and do this load the n...
asked by 27.06.2018 / 14:33