Posts by Leandro Lazari • 153 points
11 posts
-
2
votes1
answer569
viewsQ: Problems to close another spreadsheet by VBA
I am running the code below to compare data from different spreadsheets. It is running correctly, but I am not able to close the source sheets of the data. I have tried with '.Close', '.Quit' and '=…
-
1
votes1
answer526
viewsQ: Error: The Incompatible Types
I am running a PROCV in one column, looking for values of another. The code runs to a certain value and appears the error quoted. But there is no difference in the numbers, even I have already put…
-
1
votes0
answers65
viewsQ: Make clicks for interactive online chart
I need to select the information on the left side of the graph according to my need, but I cannot reference the information. I didn’t put any code because I tried it in various ways (according to…
-
1
votes0
answers718
viewsQ: Import Table from Web Page to Excel
I want to take all the data from an internet table and put it in excel. I tried with the code below, but the following error appears in the line of 'For Each': "Runtime error '438': Object does not…
-
1
votes1
answer635
viewsQ: Error '70': Permission Denied
When I run the code below, the title error appears in the 'For Each' line. This is a block of the site itself or there is some error in the code? Declara função Sleep If VBA7 Then Public Declare…
-
1
votes1
answer275
viewsQ: Problems in VBA code execution
This code clicks on the 'Legislation' tab and fills a field with a given text (2º For Each) and clicks on the search button (3º For Each). The problem is that when I run the code, it clicks on the…
-
1
votes1
answer445
viewsQ: VBA - Error: The 'frames' method of the 'Jscripttypeinfo' object failed
I need to fill the 'Legislation' tab with the text "Energy Development Account" and do the research. But when executing the code appears the error quoted in the title referring to the line "obj =…
-
1
votes1
answer1216
viewsQ: To rename a folder added the current date to the name
I have a folder where I keep data that needs to be updated daily. To not miss the history copy this folder and paste elsewhere. But, after copying and pasting the folder, I need to rename it with…
-
1
votes0
answers442
viewsQ: VBA Configuration of References
Good morning, it may be something really stupid, but I’m starting to work with VBA to search for data on the web and every time I start a new project I have to add the references "Microsoft HTML…
-
2
votes1
answer4893
viewsQ: Handling of internet explorer using VBA
At the bottom of this site "http://sdro.ons.org.br/SDRO/DIARIO/index.htm" has an icon that downloads a file .xls. I needed to click on it and save the file, but I don’t know how to do it. It follows…
-
2
votes1
answer2678
viewsQ: OPERATION OF THE EXPLORER VIA VBA
Good morning, I’m starting to work with VBA so my doubt may be very basic, but my problem is the following: When I run the code (below) it looks like an error alert on the 'For each' line' "Runtime…