SELEKSI FILE DAN SHEET

NamaFile = Cells(2, 3).Value
NamaSheet = Cells(3, 3).Value

Windows(NamaFile).Activate
Sheets(NamaSheet).Select

Create Domain in Localhost

1. Edit File httpd.conf then create VirtualHost


ServerName wordpress
ServerAlias wordpress
DocumentRoot "G:/03.DATA.WEB/00A.Personal/020.warungilmu.info"

Options Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all



2. Edit file Hosts in C:\Windows\System32\drivers\etc\hosts

127.0.0.1 localhost
127.0.0.1 wordpress

3. Restart Apache

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/