Questions tagged as 'excel-vba'

Tagged questions
0
answers

Copy existing photo in web link and paste as special bitmap into Excel cell via VBA

I'm trying to paste image (thumbnail) linked to a link as below: Ex. The main WEB page is: link From this main page, I want to copy and paste as a bitmap in Excel the image of the link: www.imdb.com/name/nm0001271/?ref_=tt_cl_i1. See...
asked by 11.08.2017 / 14:48
0
answers

Blocking of VBa templates

I've created a simple form that tells me date, date, OS, and Type. When my user tries to change some of it, it does not work, so I progame to stop the data change, but when my client selects all the cells in the worksheet and presses it deletes...
asked by 01.11.2017 / 23:46
1
answer

Search in column P for a value or and calculate this value in cell U?

From now on I want to thank @Leandro Felipe Moreira for the help with the following code: Sub teste() rng = Columns(16).End(xlDown).Row MsgBox rng For i = 1 To rng If Cells(i, 16).Value > "0" And Cells(i, 16).Value <= "100" Then...
asked by 05.06.2017 / 20:57
2
answers

Split a worksheet into several worksheets

I have a spreadsheet with 5000 rows that needs to be split into spreadsheets with 790 rows at the most. How can I do this ??     
asked by 26.05.2017 / 04:20
1
answer

Error: Incompatible Types

I'm running a PROCV on one column, looking for values from another. The code runs up to a certain value and the error quoted appears. But there is no difference in the numbers, I have already put all values as the first one to test and continue...
asked by 12.06.2018 / 18:20
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

VBA - Read a .TXT file and manipulate its lines

I'm trying to make a Query generator using Excel (VBA), but I'm not able to manipulate some data inside a .sql file. Eg: Select * From Tabela t Where t.id = 1 <PROP> Whenever he finds a line that is written PROP he should swap for...
asked by 01.10.2018 / 17:55
1
answer

Problems in running VBA code

This code clicks on the 'Legislation' tab fills a field with a specific text (2nd For Each) and clicks the search button (3rd For Each). The problem is that when I run the code, it clicks on the tab and fills in the text, but it zeroes the field...
asked by 28.03.2018 / 16:47
1
answer

Update Selenium Frame VBA

Expensive, How can I do to update a frame with Selenium in VBA? Refresh frame is an option that exists when you right-click on a frame. I can not update the whole window, just the frame.     
asked by 16.03.2018 / 13:35
1
answer

EXPLORER HANDLING THROUGH VBA

Good morning, I'm starting to work with VBA so my question may be pretty basic, but my problem is this: When I run the code (which is below) it looks like an error alert in the 'For each' line    "Run-time error '438'. Object does not support...
asked by 19.03.2018 / 13:52