Posts by Evert • 1,980 points
85 posts
-
4
votes1
answer2786
viewsA: How to format a cell from the RGB code contained in the cell itself
You will need to use VBA for this, test the code below for cell A1: Range("A1").Interior.Color = RGB(127,187,199) If you want to do this for all cells, you need to use the function Worksheet_change…
-
3
votes1
answer100
viewsA: fmBackStyleTransparent does not work in Excel VBA
Microsoft released an update (October/2016), for Office, with an error that influences the behavior of VBA. What is causing this error, as we can see in the Microsoft forum (in English): Office VBA…
-
2
votes1
answer729
viewsA: XML mapping in Excel 2013
Good morning! As far as I know and worked with XML in Excel, there are two files one works with two XML files, one containing the data (.xml) and the other containing the schemas (.xsd). I don’t…
-
6
votes1
answer1200
viewsA: Find column and position cursor in it
One option would be: Create a function to pick up the date user wants and position on top of the date: Sub buscaData() Dim DATA_ As String Dim CELULA_ As Range Dim RESPOSTA_ As Long DATA_ =…
-
3
votes2
answers3109
viewsA: Methodnotallowedhttpexception in Routecollection.php - Laravel 5.2
The problem is in View, to action tag form shall indicate the complete route path: Where are you like this: action="/es/create" Should be like this: action="{{ url('/es/create') }}" Follow full code…
-
2
votes2
answers3109
viewsQ: Methodnotallowedhttpexception in Routecollection.php - Laravel 5.2
Developing an application using Laravel 5.2, PHP7.0, Apache2 and Centos 7, I am having the following error: Methodnotallowedhttpexception. On the local server it works normally... when I publish on…
-
1
votes0
answers555
viewsQ: Bootstrap with cellular-aligned navbar
I have the following code defining a navbar with bootstrap: <nav class="navbar navbar-default"> <div class="container"> <div class="col-xs-1 hidden-xs"> <div…
-
0
votes2
answers851
viewsA: Combo Cities with Laravel 5.2
The script should look like this: @section('post-script') <script type="text/javascript"> [...] $.each(cidades, function (key, value) { $('select[name=cidade]').append('<option value=' +…
-
2
votes1
answer482
viewsA: How to treat unusual closing of a Combobox list in VBA?
A possible solution would be to use the change: Private Sub UserForm_Activate() ComboBox1.AddItem "Primeiro" ComboBox1.AddItem "Segundo" ComboBox1.AddItem "Terceiro" ComboBox1.ListIndex = 0…
-
0
votes4
answers297
viewsA: About Routes and Links
Create the structure you want, update your namespace, clear the way and just let: Route::resource('/', 'UsuariosController'); It is necessary that your controller extend to the class Controller.…
-
1
votes1
answer867
viewsA: Laravel session does not work on another page
To Session() of Laravel works in several ways, as we can see in documentation. However, if you are using the standard form you will need to give a Reflash() or a Keep() in your session to keep on a…
-
4
votes1
answer1882
viewsA: Pick up specific columns with Laravel querybuilder
To set the columns you want to select use select: DB::table('nome_da_tabela')->select('coluna1', 'coluna2')->get(); As found in the documentation.…
-
0
votes1
answer614
viewsA: Error running db:Seed command
How you are setting the data directly you can use only the file Databaseseeder.php as in the documentation as follows: DB::table('users')->insert([ 'name' => 'Admin da Silva', 'email' =>…
-
2
votes2
answers763
viewsA: How to delete dynamically created objects based on vector? (VBA/Excel)
To exclude the label should be used in the same way as in construction: Private Sub deleteLabel_Click() Dim MyLabel(0) As Object Set MyLabel(0) = Me.Controls.Add("Forms.Label.1") With MyLabel(0)…
-
4
votes3
answers3733
viewsA: Customize field name in validation error messages
The code that implements the user validation method (function) both in the login when in the creating of new users, can be overwritten in the file. The method of validation of the login is…
-
3
votes3
answers3733
viewsQ: Customize field name in validation error messages
I’m using the Laravel 5.2 Standard Authentication Controller: php artisan make:auth As the names are in English, I need to change to Portuguese. I have already set the locale to Portuguese, in…
-
0
votes0
answers78
viewsQ: Error in Curl adapter using Solarium - Solr with php 7
I use Sorl version 5.4, working perfectly the interface of Solr itself. I installed the Solarium to facilitate application development. However, when testing the examples following the initial…
-
1
votes3
answers3061
viewsA: How to use a Command Button inserted in the Spreadsheet in the VBA code?
If it is an Active-x button Active-X controls double-click on the button and it will open in VBA a Sub to create your code. If it’s a common button Form Controls, you can create your macro and then…
-
3
votes2
answers19521
viewsA: VBA - Counting the number of filled cells in the row
Hello, I believe your formula has a small error... try to use the sheet name as below: MsgBox Plan1.Range("b:b").Cells.SpecialCells(xlCellTypeConstants).Count I hope I’ve helped!…
-
6
votes1
answer677
viewsA: How to modify VBA function to write a number greater than 1 trillion in EXCEL cell?
Below the function to write monetary values in full limited to 999 trillion, I believe that with it you can adjust your code to write non-monetary number as well: Function VALOREXTENSO(valor As…
-
1
votes1
answer177
viewsA: VBA for searching photos in a folder and concatenating filenames without duplicating
In addition to the function presented (very well written by the way), I changed some codes and created other functions to facilitate reading and improve performance, performing the necessary tests…
-
1
votes3
answers1827
viewsA: Excel - Extract only numeric fields from a selection containing text and numbers
Solution found: I created a function to delete a string in a function: Function deleteString(ByVal STRING_TO_BE_DELETED As String) ' ' Deleta um texto específico ' IMPORTANTE: A origem já deve estar…
-
3
votes3
answers1827
viewsQ: Excel - Extract only numeric fields from a selection containing text and numbers
Using Excel, I need to extract numerical data from a selection. Example: Coluna 1 123 456 Bom Ruim 789 Ótimo From the above data, I need to extract the following data: Coluna 2 123 456 789…
-
1
votes2
answers165
viewsA: Keep Settings when Changing URL - Wordpress - Theme: Adventure - Organic Theme
I developed a script in bash to solve the problem. Below is the full script: #!/bin/bash # 1. Dados Gerais # 1.1 URL URL_OLD=http://very_old_url.com.br URL_NEW=http://novo_url.com.br # 1.2 Database…
-
2
votes2
answers165
viewsQ: Keep Settings when Changing URL - Wordpress - Theme: Adventure - Organic Theme
I’m having trouble in the theme settings by changing the URL of a wordpress site using the Organic Theme’s Adventure theme. I made some scripts to change the functions in the database, which is ok!…
-
1
votes1
answer403
viewsQ: How to 'Loop' in Multi-dimensional Array in Bash?
Situation: I need to create a multi-dimensional array script. Example: Table 1 >> Campos id and name Table 2 >> Campos id and telephone Current script: #!/bin/bash declare -A arr…
-
0
votes2
answers3272
viewsA: How to find information from another spreadsheet in Excel
These are some steps to accomplish what you want here... Identify the spreadsheets From what I saw in your example, the name varies not only according to the date, but also the time, because in one…
-
1
votes1
answer1565
viewsA: Select a row of the listbox object
I believe that the best solution would be to use a Combobox in Userform. My suggestion is to follow the steps below: Create a table and name a range (e.g. lst_Esporte) Create a form and encode to…
-
3
votes1
answer8849
viewsA: How to send only a spreadsheet by email in VBA and not the whole file using the code below
Ideal would be to save in a new file the sheet you want to send and pass the full path as parameter to this function, follows generic example I did as a model: Sub enviaPlanilhaAtiva() Dim oOutlook…
-
2
votes2
answers425
viewsQ: How to get the last (max) tabindex from an html form using jQuery
I need to get the last 'tabindex' of a form for when the user clicks 'tab' or 'enter' back to the first. Follows current code: $(':input').keydown( function(event) { if ( (event.which === 13 ||…
-
1
votes1
answer253
viewsQ: Mask jQuery does not work on duplicate element - same class, same id
I’m using the mask option jQuery-Mask-Plugin and I use a field duplication code; however, when duplicating the elemto, the mask does not follow, that is, the new element (duplicated) does not carry…
-
1
votes1
answer507
viewsA: How to import mysql data with VBA without defacing text
I believe that the Charset for the connection will solve the problem. myCon.Charset = "utf-8" Also check the Charset of the table. You can also test using the driver ANSI instead of Unicode used. I…
-
3
votes1
answer337
viewsA: Force numeric/language format to document
If you want to use the dot instead of the comma in all fields of the worksheet you can access the menu EXCEL > OPTIONS > ADVANCED > 'Use system separator' and define what you want. To do…
-
10
votes1
answer339
viewsQ: jQuery code works on http://jsfiddle.net but does not work on https://jsfiddle.net
I built the jQuery code in jsFiddle.net to test and it worked properly, however when sending the link, provided by jsFiddle, with https, the code stopped working. Can anyone explain why? I’m using…
-
1
votes1
answer1047
viewsQ: How to remove a single element having several with the same id
I am using a jQuery to clone an element and would like to have the feature to remove the cloned element. When I try to remove the element, for some reason, it doesn’t work according to…