Monday, April 07, 2025

Breaking News

Sunday, September 30, 2012

Manipulasi Foto Dalam Bola

Tutorial Photoshop pilihan lainnya hanya untuk anda : Membuat Foto Terpisah-Pisah Pertama-tama buat sebuah dokumen baru dengan ukuran 640 x 500 px. Lalu dengan menggunakan Gradient Tool (G) warnai...
Read more ...

Friday, September 28, 2012

VBA: Application Open FileName List all Excel File types

When you are showing a open dialog box to the user to select an excel file, by default the filter would be *.* which will show all files including excel files. and .xls and .xlsx will show only 97-2003...
Read more ...

Wednesday, September 26, 2012

VBA: Array - Return common values from two arrays

The below function will return the common values that are exist in two different arrays. This can be achieved by nested-looping concept, but this is an effective way :).IsInArray is an another function....
Read more ...

VBA: Distinct Array items - Remove duplicates

If you have an array with repeated items and want distinct items, then copy the below source code. IsInArray is an another function. Dont forget to include it....
Read more ...

VBA: IsInArray - Find a value in array items

The below script will be used to get to know whether a particular item exists in a array or not. Instead of looping this would be faster. -1 Then wordList = Join(arr, ",") ' start from the allegedly...
Read more ...

VBA: Cell Data Validation list to an array

The below function will be used to get list of Cell data validation and store into an array variable. This code is needed when checking the cell value as whether it is picked from the validation drop-down...
Read more ...

Tuesday, September 25, 2012

Cara Membuat Puzzle Gambar Burung

Membuat PuzzleHari ini saya akan menunjukkan cara untuk membuat efek sederhana namun sangat menarik. Ini terlihat seperti kaca mosaik berwarna atau puzzle.  Langkah 1. Pilih gambar yang ingin diterapkan...
Read more ...

Monday, September 24, 2012

VBA Excel : Sheet Named range into Array

The below code will be used to access the list of named-range values and pass to an array variable....
Read more ...

Thursday, September 20, 2012

Menggambar Star Wars lightsaber Yang Keren

Membuat Star Wars Lighsaber1. Buka Fotoshop dan masukan foto yang akan Anda tambahkan lightsaber. Saya menggunakan foto ini. 2. Menggunakan Rectangular Marquee Tool (M) ciptakan sebuah persegi...
Read more ...

Monday, September 17, 2012

Download Uninstaller All in one Portabel Untuk Windows

Ada banyak pihak ketiga uninstallers dengan pilihan yang tersedia. Hari ini saya tersandung ini uninstaller kecil yang menyenangkan disebut Geek Uninstaller. Ini adalah aplikasi portabel yaitu tidak...
Read more ...

VBA - Extract notes section from PPT

The below code will be used to extract the notes section from Powerpoint slides to excel sheets range. We have seen a similar example of copy-pasting data from excel to powerpoint. This is a reverse...
Read more ...

VBA - Unzip files using VBA

The below code will Unzip a *.zip file to a specific folder. We have already seen couple of examples like 'Accessing system special folders' and 'Creating shortcut of an system application', This code...
Read more ...

VBA - Protect Sheet from User / Allow macro

Generally, if you want your vba code to run on a protected sheet, you wrap your code in unprotect/protect statements in every procedure or function. You also have to remember to protect the sheet in...
Read more ...

VBA - Export to Powerpoint

The below code will be used to copy paste a excel range (named range) to a powerpoint slide, this code has an ability to add new slides (at the End/Beginning) if you run a loop for 'N' number of slides....
Read more ...

VBA - Download files from sharepoint

The below VBA code will be used to download files from a sharepoint folder at one-click. I have got this code through surfing, this is quite usefull for the people who involves their day to day job...
Read more ...

Append string to a existing notepad (.txt) file in sharepoint

The below code will be used to append string to an existing text file in a sharepoint folder, you can do the same function with an existing folder in your computer/ shared folder.e.g. When you want...
Read more ...

Sunday, September 16, 2012

Mengatasi Blackberry Yang Hilang

Blackberry merupakan salah satu platform ponsel smartphone terlaris di Indonesia saat ini. Banyak dari kalangan masyarakat menggunakan Blackberry untuk kegiatan sehari-hari bahkan untuk keperluan bisnis...
Read more ...

Mengatasi Laptop Yang Hilang

Mungkin anda pernah merasakan perasaan yang sangat jengkel ketika anda kehilangan/kecurian Laptop anda. Tetap saat ini tidak perlu terlalu khawatir, karena sekarang sudah ada software yang dapat melacak...
Read more ...

Saturday, September 15, 2012

Membuat Foto Menjadi Lukisan Minyak

Lukisan Minyak Tutorial ini mengajarkan Anda bagaimana mengkonversi gambar normal Anda ke lukisan minyak. Buka gambar yang akan dikonversi ke sebuah lukisan cat minyak: - Tekan control + j untuk...
Read more ...
Designed By Published.. Blogger Templates