Display Date in two digit Excel to mySQL

=YEAR(L5)&"-"&IF(LEN(MONTH(L5)) = 1,CONCATENATE("0",MONTH(L5)),CONCATENATE("",MONTH(L5)))&"-"&IF(LEN(DAY(L5)) = 1,CONCATENATE("0",DAY(L5)),CONCATENATE("",DAY(L5)))

Find String in Cell

If InStr("Look in this string", "look") = 0 Then
MsgBox "woops, no match"
Else
MsgBox "at least one match"
End If

End Sub

Joomla Links index.php

Q: Why Joomla link always go to error index.php folder?

A: Step­By­Step­Introduction

1. Log in as an administrator using the Joomla! Back­end.
2. Click on the “Global Configuration” icon.
3. Locate the right panel called “SEO Settings.”
4. Activate the options desired in the following order.

SpinnerChief Error

Q: SpinnerChief the application failed to initialize properly (0xc0000135). Click on OK to terminate the application

A:

APLIKASI OTRS

OTRS is an open source software system for managing a wide range of business processes, from Help Desk to Support Center to IT Service Management. Based on a set of functions built on a "trouble ticket," OTRS is built to allow support, sales, pre-sales, billing, internal IT, support desk and many other departments to react quickly and responsibly to inbound inquires. Do you receive many e-mails and want to answer them with a team of agents? You're going to love OTRS!

http://otrs.org/

Install Software

Office 2000
VPN Client
SAP GUI
Confiker
Setup Mcafee update
Setup Windows update
7zip
acrobat reader 8
MW Snap
SP Winn XP
Setup Printer
Setup Oulook
Copy data
fortmat d:

Create User

CREATE USER 'ps_dev'@'localhost' IDENTIFIED BY 'ps3dev';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON ps_sales_dev.*
TO 'ps_dev'@'localhost';

Toolbar Enable

Sub reset()

Application.CommandBars("Cell").Reset

Application.CommandBars("Cell").enabled = true

End Sub

Create password phpmyadmin

1. change the file config.inc.php (c:\xampp\phpmyadmin\

from
$cfg['Servers'][$i]['auth_type'] = 'config';
to
$cfg['Servers'][$i]['auth_type'] = 'cookie';

2. change password phpmyadmin from menu phpmyadmin
3. replace new password in config.php in c:\xampp\htdocs

Forward URL

< head >
< META HTTP-EQUIV="Refresh" CONTENT="0; URL=http://elearning.frisianflag.co.id">
< title ID=titletext>Under Construction ..< /title>
< / head >

Cron PHP script sheduller

## 1. Create php file ##

// your code to run via cron
// Updates stock
< ? php

$dbhost="localhost";// YOUR HOST NAME USUALLY LOCALHOST
$dbuser="root"; // YOUR DATA BASE USER NAME USUALLY ROOT
$dbpass="pass"; // YOUR DATA BASE PASSWORD
$dbname="";// YOUR DATA BASE NAME

mysql_connect($dbhost, $dbuser, $dbpass) or die("CANNOT CONNECT TO DB-HOST");
mysql_select_db($dbname) or die("DATABASE NAME PROBLEM");

$sql = "UPDATE accountinfo a set TAG = (SELECT b.location FROM ocsweb.frisianipmapping b , ocsweb.hardware c where b.IPmapping =c.IPADDR and a.hardware_Id=c.id)";
mysql_query($sql) or die("SQL ERROR:

---

".$sql);


?>


## 2. SETTING ENVIRONMENT ##

- click mycomputer >> properties >> environmen, then add the variable of 'PATH' with ";C:\xampp\php\"

## 3. CREATE BATCH FILE ##

@echo off
echo schedulle_running
php update.location.php

## 4. SETTING CRON SCHEDULE ##

start >> control panel >> schedule, choose the batch file

Function get URL in Excel

Create in macro like function below:

Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function

then open excel, type in a cell "=GetURL(A1)" for link/url you will capture


after that, you can correction the URL using macro below.

For URL = 6 To 329
AddressName = Cells(URL, 23).value
Range("W" & URL).Select

Selection.Copy
Range("L" & URL).Select
ActiveSheet.Paste
Application.CutCopyMode = False
AddressURL = Cells(URL, 27).value

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=AddressURL, _
TextToDisplay:=AddressName
Next