Skip to content

Instantly share code, notes, and snippets.

@izazueta
izazueta / Buscar_Celda.vba
Created September 2, 2015 15:41
Buscar valor en una matriz y devolver la posición de la celda (VBA)
Function Buscar_Celda(valor, matriz As Range)
Dim celda As Range
For Each celda In matriz
If celda.Value = valor Then
Buscar_Celda = celda.Address
Exit Function
Else
Buscar_Celda = "no existe"
End If
@izazueta
izazueta / GetURL.txt
Created February 12, 2015 23:13
VBA code to get URL from text in Excel Author: Ellesa (https://superuser.com/a/430410/98967)
VBA Module
Public Function GetURL(c As Range) As String
On Error Resume Next
GetURL = c.Hyperlinks(1).Address
End Function
In Excel cell
=GetURL(A1)
#!/bin/bash
DB_NAME="dbname"
DB_FILE="$DB_NAME-`date +%Y%m%d_%H%M%S`"
DB_BK_FOLDER="/your/folder/"
DB_BACKUP="$DB_BK_FOLDER$DB_FILE"
DB_USER="dbuser"
DB_PASSWD="dbpws"
FTP_SERVER="x.x.x.x"
FTP_USER="ftpuser"
FTP_PASSW="ftpws"
@izazueta
izazueta / chmod-files-folders.sh
Created May 9, 2014 17:08
Change all files or folder permissions with chmod
#!/bin/bash
# files
sudo find . -type f -exec chmod 644 {} +
# folders
sudo find . -type d -exec chmod 755 {} +
@izazueta
izazueta / 0_reuse_code.js
Created May 9, 2014 16:47
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@izazueta
izazueta / visor-archivos-online.md
Last active July 20, 2023 09:32
Google Docs Viewer & Office Web Apps Viewer

Google Docs Viewer

Only files under 25 MB can be previewed with the Google Drive viewer.

Google Drive viewer helps you preview over 16 different file types, listed below:

  • Image files (.JPEG, .PNG, .GIF, .TIFF, .BMP)
  • Video files (WebM, .MPEG4, .3GPP, .MOV, .AVI, .MPEGPS, .WMV, .FLV)
  • Text files (.TXT)
  • Markup/Code (.CSS, .HTML, .PHP, .C, .CPP, .H, .HPP, .JS)
  • Microsoft Word (.DOC and .DOCX)
@izazueta
izazueta / Custom.css
Created January 16, 2013 19:23
Chrome Dev Tools Darker Skin by Darcy Clarke - 2011
/**********************************************/
/*
/* Darker Skin by Darcy Clarke - 2011
/*
/* For how to install, or more themes, check out:
/* http://darcyclarke.me/design/skin-your-chrome-inspector/
/*
/* Color scheme is based on Joe Bergantine's Specials Board:
/* http://joebergantine.com/werkstatt/seestyle
/*
@izazueta
izazueta / joomla_addAdminUser.sql
Created June 5, 2012 21:38
Joomla: Agregar usuario administrador con instalación manual
INSERT INTO `#__users` VALUES (62, 'Administrator', 'admin', 'your-email@email.com', '21232f297a57a5a743894a0e4a801fc3', 'Super Administrator', 0, 1, 25, '2005-09-28 00:00:00', '2005-09-28 00:00:00', '', '');
INSERT INTO `#__core_acl_aro` VALUES (10,'users','62',0,'Administrator',0);
INSERT INTO `#__core_acl_groups_aro_map` VALUES (25,'',10);