Posts by silvio pontes • 109 points
5 posts
-
1
votes1
answer1517
viewsQ: VBA - Popular array string and do not repeat values
I have an Excel Workbook x. This Workbook has 3 spreadsheets. The 1st is Animals still empty; the 2nd is Birds and we have repeated values and the 3rd is Mammals also with repeated values. How to…
-
1
votes1
answer727
viewsA: Error closing serial port in c#
Try that and instead of CommPort enter the name of your class that addresses the Serial Port. void CloseComPort() { CommPort com=CommPort.Instance; com.Close(); } I hope it is the beginning of the…
-
3
votes1
answer270
viewsQ: Lock reading, opening and editing file
How to block the opening, reading and editing of a file by the user during the period the application is running? An application has a relatively long data collection period. This application reads…
-
2
votes1
answer141
viewsQ: Protect Excel spreadsheet in C#
In a C#application, you can have from 1 to 2100 hours of data collection. Data is saved in a CSV Excel spreadsheet every minute. With the code below we can hide and show the file. #region string…
-
3
votes3
answers138
viewsQ: Is it possible to use for loop to reduce C code?
I have the following function:To. It is possible to use for loop B to generate the declarations as in the function To? What to wear instead of printf to become a declaration?…