Posts by César Rodriguez • 364 points
21 posts
-
-2
votes0
answers11
viewsQ: Accentuation in Cakephp
Hello, my dear! The doubt below is well Noob, but it’s burning my neurons... I recently installed Cakephp 4.2.8, PHP 7.4.9. I’m walking through the Cakephp tutorial, and I made a Bake for one of my…
-
0
votes1
answer25
viewsA: How to bring file information into a folder
The two dimensions come together (probably there is a property that brings them separately), but I tested here with an image . jpg and got. Reference to the library Microsoft Shell Controls and…
-
0
votes1
answer154
viewsA: VBA excel perform action from dropdown selection
Hail! The event that detects changes in a given field is the Change of the object Worksheet. If the routine AdicionaConta is already in object code Worksheet of this specific worksheet, just add the…
-
0
votes1
answer119
viewsA: How to access menu mouseover with VBA
Salve, Diego! The place you will click just runs this script setUrl(this,' http://siga.saude.prefeitura.sp.gov.br:80/sms/preenchimentoLaudo.do?method=initUseCaseAndInsert&subsystem=apac').…
-
1
votes1
answer339
viewsA: Click on the link with vba
Dear Icarus, your problem actually starts well before. The line IE.document.getElementsByTagName("button") 'aciono o botão pesquisar does absolutely nothing. It neither calls any method, nor…
-
1
votes1
answer243
viewsA: Help VBA create folders and subfolders and save file inside
You’re gonna have a problem here: sub_p1 = save & "\" & subPasta & "\" & "info" Because some lines above you have already defined that string subpasta is the entire path of the…
-
0
votes1
answer85
viewsA: VBA does not show the options and Methods automatically
That is the option Autolistar membros, which is marked on the print you sent. One option to do this manually is to right-click and select Listar propriedades/métodos, but it’s so cool to do it by…
vbaanswered César Rodriguez 364 -
0
votes1
answer67
viewsA: VBA interaction with Internet Explorer and use of getelementsbyclassname does not work
You didn’t exactly pass the error behavior, which makes it a little difficult to analyze (for example, does it fill in Icker and then do nothing? Or he really makes a mistake?). You can’t analyze…
vbaanswered César Rodriguez 364 -
0
votes1
answer64
viewsA: Execution Error 424 - Import multiple XML files in VBA
Hail, my dear! I believe the mistake happened because the variable XML not defined. As XML is Nothing, has no properties (in your case, the FileName which you tried to assign). "The object is…
-
1
votes1
answer284
viewsA: Runtime error 13. Incompatible types
Hail, my dear! The problem is that you are comparing data with a string that is not date (and sometimes even an empty string). If you leave one comparison at a time on If, will see that the problem…
-
0
votes2
answers2132
viewsA: How to replace Comma by Point in VBA
Your problem is quite simple: you are mixing garlic with oranges. You are looking for a string (",") inside a cell that contains a non-string value. I would bet high that the prices in column F are…
-
0
votes1
answer249
viewsA: Help with VBA and web to populate web form fields with cell data and trigger report output button
Dear Bruno, I think this one will be quiet. Again, as in your previous doubt, the method getElementsByTagName returns a collection of elements that have the tag passed as parameter. In this case, by…
-
0
votes1
answer111
viewsA: Access menu mouseover by VBA
You didn’t describe the mistake, which makes it a little difficult to help. Your code (up to the commented part) does not contain an appropriate condition to click on the correct link when it is…
-
2
votes3
answers426
viewsA: Select area escpecify in excel VBA spreadsheet
If your spreadsheet does not have other discontinuous populated areas, it would be reasonably simple to use UsedRange. For example: Private Sub CommandButton1_Click() Dim planilhaB As Worksheet Dim…
-
2
votes1
answer500
viewsA: Several filters with VBA
Apparently, if this code works for one tab, just iterate on several, which can be done like this: Dim Plan as Worksheet For each Plan in ActiveWorkbook.Sheets ' Pressupondo que o arquivo com as…
vbaanswered César Rodriguez 364 -
4
votes1
answer128
viewsA: Copy, Filter paste vba
You can iterate the lines using a statement For cont = Plan.UsedRange.Rows.Count To 1 Step -1 'Plan é a referência à planilha; cont é uma variável do tipo long. 'Recomendo fazer em ordem decrescente…
vbaanswered César Rodriguez 364 -
1
votes2
answers10196
viewsA: Delete table lines through VBA
The question was somewhat generic, but let’s go to the path of stones for you to make your adaptations. You have not explained if the intention is to delete all the table rows or just a few. From…
excel-vbaanswered César Rodriguez 364 -
1
votes2
answers1094
viewsA: How to handle IE objects that do not contain an ID? VBA Access
If you inspect the element, you will notice that the fields you want to edit are inside a iframe, whose source is /proc/sistema_push/. Therefore, to reference the email and password fields, you need…
vbaanswered César Rodriguez 364 -
0
votes2
answers152
viewsA: Vba interacting with IE
If the objects you want to click are those of the class clicavel, just iterate using the method getElementsByClassName: For Each obj In IE.Document.getElementsByClassName("clicavel") obj.Click Next…
vbaanswered César Rodriguez 364 -
2
votes1
answer487
viewsA: Update Frame Selenium VBA
You didn’t send any code, or clarify the browser, but I think it would work: Dim Oxente As Selenium.ChromeDriver Oxente.SwitchToFrame "identificador-da-frame" 'Vai para a frame Oxente.Refresh…
-
1
votes1
answer635
viewsA: Error '70': Permission Denied
It rolled here, with a small detail: The variable el is a collection of tables (even if it contains a single table), so it was necessary to change the For to reference the first element of el (that…