Posts by Clebson Omena • 63 points
8 posts
-
0
votes1
answer281
viewsQ: how to populate a site field using excel vba
I would like to know how to fill the field. I have tried several combinations to fill the highlighted textbox in the photo, but nothing works. I tried things like: IE.document.all("stk…
-
1
votes1
answer279
viewsA: How to update a website page after changing the value of a field by VBA
Look at the solution I found. It’s not elegant, but it’s working (I don’t know how long)... If anyone has a better idea, I accept. Sub Links() Dim ie As Object Dim tabela As Object Dim Liga,…
-
1
votes1
answer279
viewsQ: How to update a website page after changing the value of a field by VBA
Good night. I wonder how I can update the page with the date I informed by VBA. I put the date but the page does not change. Since there’s no button, I don’t know what to do. Sub Links() Dim ie As…
-
0
votes0
answers1608
viewsQ: Import access data to excel based on criteria
I have a table in access and I can already pull the data from it to an excel spreadsheet (I can do this using the code below), but I would like to be able to pull only some data (based on criteria,…
-
1
votes1
answer2259
viewsQ: Excel vba: Saving data from a spreadsheet in . txt format
Good afternoon. I have the macro below and it already does almost what I want (creates a txt file with the data of the Historico spreadsheet, always rewriting the file, ie, does not create several…
-
0
votes0
answers110
viewsQ: Graphic design
Good evening. You would know how to mount the graphic of the figure below, being that in the graph the numbers 1, 2 .... should take the 3 columns on the side, leaving something like: 1 1 of 10; 10%…
excelasked Clebson Omena 63 -
0
votes0
answers1102
viewsQ: Import sheet charts to userform (excel vba)
I have to import 3 charts for a userform. I had even managed, but suddenly started to give errors, then I put the code "On Error Resume Next" (but this is not solution, just does not lock my form…
-
2
votes1
answer3446
viewsQ: How to import data from internet to excel vba
I’m trying to download a table from the site: "http://www.scoutscartola.com/mercado", and I already "got". But there is a problem in my code. I want the user to define the team. This is done by…