Posts by Vinicio Schmidt • 82 points
12 posts
-
1
votes1
answer93
viewsA: I’m trying to put a timer in my python code
The easiest way is to use a delay in conjunction with a random time. import time from random import uniform numero_aleatorio = uniform(2,5)) #Gera um numero aleatório entre 2 e 5…
pythonanswered Vinicio Schmidt 82 -
0
votes1
answer500
viewsA: Transfertext method
This is because the language of the operating system is working with a different character map. As the language configured is English or other than English (I assume) the comma is used as a decimal…
-
1
votes1
answer901
viewsA: VBA - Generate a multi-excel PDF file
There is a simple solution with the integration between Excel and Acrobat: Prepare the files that will be "united" Sub Combine_PDFs_Demo() Dim strPDFs(0 To 2) As String Dim bSuccess As Boolean…
-
1
votes2
answers6120
viewsQ: Extract SAP data through Excel
Hello! I’m trying to integrate Excel with SAP via VBA. I would like to run the transaction "MB51" with some parameters like date, deposit and movement and bring the data obtained to the Excel…
-
1
votes1
answer1633
viewsA: Run python script on android via one-click file extraction
You can use the Qpython to run your code because it works as a IDLE inside your device. However, to "make an icon" you need to generate a ". apk" and for that there is the framework "Buildozer" that…
-
0
votes1
answer3988
viewsA: Redeem the value of a variable in VBA and put in a cell in Excel
The value of a variable is destroyed after the execution of a function. To save the value of the same it is necessary to allocate this value somewhere as for example in a cell while the code is…
-
0
votes2
answers119
viewsA: MACRO to insert image with respect to drop-down list
You can use the cbxListaSuspensa_change event so that each new change in your list a macro is excommunicated and from this execution the image is changed to the image path that is contained in the…
-
0
votes2
answers1694
viewsA: VBA copying Brazilian standard date in American standard
Try to edit the date patterns of your computer in the control panel or in the code add the formatting of the data in the column with: Sheets("CAPA").Select Range("B2", "B50000").NumberFormat =…
-
0
votes1
answer49
viewsA: How to transfer an HTML table into a Data Frame
It is possible to extract the data with the module beautifulsoup and attach these files to a dataframe or variables. The code below extracts the title from the file and stores it in the title…
-
-5
votes1
answer1825
viewsQ: Where can I find the php.ini file on my hosting server?
I created a website and hosted it in a third-party service. It’s working very well but I don’t know where is the php.ini configuration file to configure some things. Does anyone know how to locate…
phpasked Vinicio Schmidt 82 -
1
votes1
answer677
viewsQ: How to set the filters in a Pivotchart through a macro in Excel?
I made a VBA form and wanted to click on a button the filter properties of the dynamic graph associated to a table in Excel if they changed.
-
2
votes1
answer614
viewsQ: VBA events in Powerpoint
Hello, Is there any event in Powerpoint that allows the execution of a subroutine when selecting a slide. For example, the presentation is running... When you get to slide 120 it has to run a…