Posts by h1k3r • 925 points
29 posts
-
14
votes2
answers2682
viewsQ: Is it possible to declare Unknowns in Python to calculate constants of a Mathematical function?
I need to assemble a quadratic function Y = Ax² + bx + c from values of X and Y acquaintances. In this case, I’m trying to H(Q) = aq² + Bq + c (Gauge height as a function of flow rate). Where: H1 =…
-
1
votes1
answer35
viewsQ: Python3 does not accept file.name
I’m with a script where I want to take the name of each file along the first line within each file and pass those in a list within a txt. #modifica titulos de arquivos import os import glob s=("-")…
python-3.xasked h1k3r 925 -
3
votes3
answers2681
viewsQ: Adding text files to python
I have a series of files in . txt and I would like to add them / join them all in one using a python script. something like: #Abre o arquivo que receberá a soma de todos os outros…
python-3.xasked h1k3r 925 -
0
votes1
answer908
viewsA: Set the color of a series on a new chart in the worksheet
I made a script to generate a new chart, according to the defined color parameters and cells of a column, according to lines containing value in cellule. The Function Contalinhas serves to detect…
-
0
votes1
answer908
viewsQ: Set the color of a series on a new chart in the worksheet
In Vbaproject I have a row that selects a certain series from the chart Sub MudaCor() ActiveChart.SeriesCollection(n).Select End Sub Being "n" the serial number I need to select. the series colors…
-
4
votes1
answer866
viewsQ: Automatic Logon in SAP Bexanalyzer by Vbaproject
(UPDATED) In excel I have a supplement that gives access to the BI system, to access / stratify data in a query already specified / structured. In my Vbaproject I am referencing the Add-in to call…
-
3
votes1
answer393
viewsQ: Why does input work in Python 3.x and not 2.7?
I ran this same code with just a few minor differences in syntax to suit the right mode of script in Python version 2.7.9 and also in Python 3.4.2 Script I ran in Python 2: name=input("tell me your…
-
2
votes1
answer630
views -
3
votes3
answers272
viewsQ: Use of increments in C
What is the difference in the use of increments in C language, considering an integer N? N++ ++N N-- --N
-
0
votes1
answer481
viewsQ: Combination of digits from A to Z (Crosse Join)
I’m running a four-digit algorithm from A to Z. I did it using vectors in Pascal like this: var i:integer; j:integer; k:integer; l:integer; vect1:array[1..26] of string; vect2:array[1..26] of…
-
3
votes2
answers418
viewsA: Software that needs license for commercial use
Anywhere, mainly company with cnpj, duly registered, should only use licensed product, except in cases where the software developer allows use with limited version, for learning or non-commercial…
-
3
votes1
answer64
viewsQ: Would an alphabetical sequence counter be possible?
I’m making a code in Pascal where one of my arrays has alphabet values (from A to Z) for a personal project of the type Questions and Answers/ Meaning A to Z: aux[1]:= 'a'; aux[2]:= 'b'; aux[3]:=…
-
3
votes2
answers2501
viewsA: Delete a macro using another
I thought that way too: Sub DeleteModule() Dim VBProj As VBIDE.VBproject Dim VBComp As VBIDE.VBComponent Set VBProj = activeworkbook.VBProject Set VBComp = VBProj.VBComponent("Module1")…
-
6
votes2
answers2501
viewsQ: Delete a macro using another
How to program one macro to delete another? Would it be something like, when, I need to call? Ex.: Sub callmacro() Call macro1 End sub And better yet, if I want to program it to delete itself? Ex.:…
-
3
votes3
answers4914
viewsA: Run VBA code from text file
You can Create a Batch File to Call Your Excel File. call C:\diretorio\do\arquivo\ArquivoExcel.xlsm And in your Excel file you leave your macro as auto executable when opening the spreadsheet. Ex.:…
-
2
votes2
answers3791
viewsQ: Write current Directory to a text file
In a batch program I have: echo Date >c:\users\...\testecmd.txt Write the current date in a text file. Assuming I don’t know where is the directory in which the auto executable is, how do I get…
-
-1
votes1
answer203
viewsA: I cannot change a record in a Pascal . dat file
Then @A.Barbosa I opened your code by Pascalzim version 6.0.3b4 Here he points out the error in Rent: And here’s the mistake in returning: In both cases the pointed error is in the line where the…
-
1
votes2
answers229
viewsQ: Add to Text File Using pascal
I did this algorithm on Pascal that feeds numerical information into a text file. program Pascal; var i:integer; Vect:array[1..1001] of integer; Myfile: text; begin i:=1; for i:=1 to 999 do…
-
2
votes1
answer324
viewsA: Hide results in Excel
@Maximilian I made a spreadsheet of this kind. In a new spreadsheet open the vba (Alt + F11) And click "This workbook" Then paste the following code, this will ensure that every time the worksheet…
-
3
votes2
answers923
viewsA: Generate Code text file done in Pascal
I found out! my question was answered on Stackoverflow The code went like this: Program Pascal ; var i:integer; vect:array[1..1001] of integer; Myfile: text; begin i:=1; for i:= 1 to 999 do…
-
2
votes2
answers923
viewsQ: Generate Code text file done in Pascal
I have a code in Pascal. Here’s the thing: Program Pzim ; var i:integer; vect:array[1..1001] of integer; Begin i:=1; for i:= 1 to 999 do vect[i]:=i+1; for i:= 1 to 999 do writeln (vect[i]); readln;…
-
8
votes2
answers13641
viewsQ: Deletion of repeated words using Notepad++
It is possible to delete repeated words in a text file using Notepad++?
-
3
votes1
answer1395
viewsQ: Sum of several text files *.txt
I have a series of files in . txt and would like to add them / join all in one (Regardless of order). It is possible to do this by word vba, some other text editor, or other means?…
-
3
votes1
answer169
viewsA: Numberlist with Visualg
I found it! 1° The variables have values declared within the " for knife". In any code this makes the loop infinite. 2° In "write(.)" the variables are written in quotation marks. What characterizes…
-
4
votes1
answer169
viewsQ: Numberlist with Visualg
Problem with this algorithm in visualg The code is making infinite loop "Numberlist" // Função : // Autor : // Data : 09/02/2016 // Seção de Declarações var a1,b1,c1:inteiro inicio // Seção de…
-
0
votes3
answers4588
viewsA: Algorithm with structure PARA and SE
algoritmo "semnome" // Função : // Autor : // Data : 09/02/2016 // Seção de Declarações var nome, sexo, f, m: caracter cntf, cntm, i,…
-
1
votes1
answer633
views -
2
votes1
answer972
viewsA: Skip column to each N counted rows
I did it! I changed my logic on parole mod. Ex.: Every 100 rows the column counter changes to another 1. Stay this way: Sub numberlist() Application.ScreenUpdating = False Application.Calculation =…
-
2
votes1
answer972
viewsQ: Skip column to each N counted rows
I need help with vba. When inserting values using Line counter, I want to change column, every N number of rows. E.g.: every 100 rows counted and automatically inserted values, the column is…