PT. HM. SAMPOERNA, Tbk. - Pasuruan Jawa Timur

INHOUSE TRAINING VBA MACRO PROGRAMMING

PT. PLN PERSERO MALUKU / MALUKU UTARA

INHOUSE TRAINING I.S GOVERNANCE

O-Shop, SCTV, Infotech (Jakarta)

PUBLIC TRAINING MAGENTO ADVANCED

PT. ASKRINDO - JAKARTA

PUBLIC TRAINING PMP PMBOK EXAM PREPARATION

Bank Fama International - Bandung

INHOUSE TRAINING CYBERSECURITY AWARENESS PROGRAM

Thursday, December 25, 2014

Freelance Certified IT Trainer Bandung

Freelance IT Trainer, Pengajar Komputer, Inhouse Trainer, Management Trainer , Hery Purnama

Hery Purnama 081.223344.506 , Trainer Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer, Inhouse Training Certified IT Trainer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun sebagai IT Trainer & IT Consultant

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, PHP SMS Gateway, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS


Training Topics :

  • Google Application Integration Toolbox  for web developer
    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    Web Integration with Facebook API developer toolbox
    Web Development with CMS Wordpress
    Web Development with PHP Yii Framework
    Web Development with PHP CodeIgniter
    Project Management Methodologies  With Microsoft Project 2010
    SEO and Internet Marketing
    RDBMS - Database Concept
    ITIL V.3 Foundation
    Building Database Application with Microsoft Access 2010
    Microsoft Access 2010 VBA Macro programming
    MYSQL Server DBA Fundamental
    Object Manipulation with Adobe Photoshop CS
    CorelDraw X6 for Marketing and Promotion
    Google Sketchup 3D for Building Interior
    Building Flash Animation with SWISHMAX
    Building PHP MySQL - AJAX Web Application with Adobe Dreamweaver CS
    Building  ASP.Net Application with IronSpeed Designer
    Building PHP MySQL Web Application with CodeCharge Studio
    Mobile Application Development for Android with Jquery Mobile, MySQL & Phonegap
    HTML 5 for Mobile Application Development
    Microsoft Office 2010 (WORD, EXCEL, POWERPOINT)
    Microsoft Excel Visual Basic for Application (VBA-Macro)
    Networking Essential
    Installing, Configuring and Administering Windows Server 2008
    Installing, Configuring and Administering UBUNTU
    Installing and Configuring Exchange Server 2008
    CISCO Router
    Application Programming with VB.NET
    Web and Application programming with ASP.NET
    Web and Application programming with PHP - MYSQL
    Building Rich Internet Application  with PHP and Sencha ExtJs
    Building web application with PHP MySQL & AJAX Jquery
    Building Event Scheduler System with PHP AJAX and SMS Gateway
    Computer for Secretary and Admin Staff (Networking  Essential, MS. Outlook, Document Security and sharing, MS. Office Integration, File Archive and data backup - Recovery, etc.)
    Kerio Winroute Firewall
    SQL Server 2008 Database Design & DBA Fundamental


My Clients:

  • PT. Sampoerna Tbk - Bandung
  • PT. Asuransi AXA Indonesia - Jakarta
  • Icon Plus (Icon PLN - jakarta)
  • Bank Ekonomi - Jakarta
  • PT PLN (Persero) PUSHARLIS UWP III
  • PT. Karenindo Citra Utama - Jakarta
  • ITENAS - Bandung
  • Universitas Bina Nusantara (BINUS - Jakarta)
  • Bank Jabar Banten (BJB)
  • AMDOCS - Jakarta
  • PT. Elnusa, Tbk.
  • PT. Sarana Multigriya Finansial / SMF (Persero)
  • PT. Pertamina Geothermal Energy (Thamrin - Jakarta)
  • PT. Indonesia Asahan Alumunium (INALUM- Medan)
  • UIN SUSKA - Riau
  • Rumah Sakit AWALBROS Bekasi
  • Universitas Andalas
  • Politeknik ACEH
  • Pusinfowas BPKP - Jakarta
  • Asuransi Takaful - Jakarta
  • PT. Freeport , Tbk - Tembagapura Papua
  • PT. Gerbang Sinergi Prima - Bandung
  • PT PLN (PERSERO) UIP TRANSMISI ISJ - jakarta
  • PT. CG Power System Indonesia - Bogor
  • PT. Pertamina (Persero) - Jakarta
  • Bank CIMB Niaga -  Jakarta
  • Ikatan Mahasiswa Teknik Metalurgi ITB - Bandung
  • PT. Pupuk Kijang - Cikampek
  • PT. Pertamina (Persero - Jakarta)
  • Bakrie Telecom Jakarta
  • SMKN 2 Garut
  • PT BES Kelapa Gading Jakarta
  • PT. Telkomsel - Jakarta
  • PT. Hutama Karya Persero (Bandung)
  • PT. Seascape Survey Indonesia
  • PT. Pupuk Kaltim
  • Dana Pensiun Pupuk Kaltim
  • PT. Sarinah (Persero)
  • PT. Weda Bay Nickel (Halmahera)
  • Taq-Taq Operating Company Ltd (Kurdhistan - Irak)
  • EMP MALACCA STRAIT SA - Jakarta
  • Bank BTPN Jakarta
  • PT. Sarana Multi Infrastruktur (Persero)
  • PT. Medco Energi - Jakarta
  • PT. ANTAM, Tbk.
  • Unversitas Islam Indonesia (Teknik Informatika)
  • Institut Teknologi Telkom Bandung
  • Politeknik Negeri Malang
  • PT. KPEI
  • DPPKAD Kabupaten Gresik
  • PT PJB UPHB
  • PT. Krakatau Steel



    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    (Inhouse ICON PLN Jakarta)
    icon PLN inhouse sisindotek
    Inhouse Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Single Marker, Multiple marker Custom Marker , Polyline dan lainnya.
     
    Microsoft Excel Advance for Business, Accounting & Management (Bank BJB - 4 Angkatan)
    Bank BJB inhouse sisindotek
    Kegiatan inhouse training dengan Bank BJB sebanyak 4 angkatan dengan total peserta 26 orang membahas pemanfaat excel dengan tingkatan yang lebih tinggi berupa pemanfaatn formula, function baik yang sudah umum ataupun yang tidak umum untuk membuat kemudahaan dalam pengelolaan data buat kebutuhan bisnis, Akuntansi ataupun manajemen.
     
    Building Event Scheduller Application with PHP and SMS Gateway (PLN)
    Training ini kembali diikuti oleh klien exclusive group dari PT PLN (PERSERO) UIP TRANSMISI ISJ, training ini membahas cara
    membuat aplikasi Event Scheduller dengan PHP, MySQL dan SMS gateway sebagai notification systemnya
     
    Mobile Application development for Android using Jquery Mobile and Phonegap (Bakrie Telecom)
    Inhouse Training membahas pemanfaat framework JQM dan phonegap dipadukan dengan PHP Ajax untuk membuat aplikasi berbasis Android dengan mudah
     
    Project Management Methodologies with MS Project (Inhouse Training INALUM Medan)
    Inhouse Training Project Management with MS. Project bersama staff dari PT. Indonesia Asahan Alumunium (INALUM) , Training membahas konsep Project Management dan implementasinya ke dalam software MS. Project 2010, termasuk dalam pembahasan adalah Project Management Lifecycle, Cost, Budget dan metodologi seperti PERT, CPM, PDM dan juga Earned Value Concept (SV, CV, CPI, SPI, BCWS, BCWP, ACWP dll.
     
    Excel VBA Macro (Inhouse training PGE Indonesia)
    Training Excel VBA Macro Programming bersama staff dari PT. Pertamina Geothermal Energy - Jakarta, Training ini membahas pemograman
    di Excel untuk melakukan otomatisasi dan pengembangan kinerja excel untuk memenuhi kebutuhan yang lebih kompleks
     
    ITIL v3 Foundation (Exclusive Group)
    Training ITIL v.3 Foundation yang diselenggarakan di Hotel Bintang 4 (DeJava Hotel , PVJ Bandung) diikuti oleh 3 peserta dari staff PUSINFOWAS BPKP jakarta
    Training ini bertujuan memahami konsep dari pengelolaan IT berbasis layanan (IT Service Management) berdasarkan framework IT Infrastructure Library (ITIL) versi 3. Beserta tambahan skenario studi kasusnya dan implementasi menggunakan ITSM software simulation serta simulasi persiapan ujian ITIL
     
    Excel VBA Macro (Exclusive Group)
    Training Microsoft Excel Visual Basic for Application (VBA - Macro) bersama 7 peserta dari PT. Freeport , Tbk (Exclusive Group) yang terbagi atas 3 gelombang / Periode
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini. Dikarenakan paket exclusive group maka training ini juga khusus membahas kasus khusus PT Freeport untuk diterapkan di bagian planner PT Freeport sesuai kebutuhan pekerjaan.
     
    Building Integrated Map Website with PHP MySQL & Google MAP API V.3
    Training Building Integrated Map Website with PHP and Google Map API V.3 diikuti oleh peserta Exclusive Group dari PT PLN (PERSERO) UIP TRANSMISI ISJ
    Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Custom Marker dan lainnya.
     
    Inhouse Training Microsoft Excel VBA Macro
    Inhouse Training Microsoft Excel Visual Basic for Application (VBA - Macro) bersama 15 peserta dari Ikatan Mahasiswa Teknik Metalurgi ITB Bandung
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini.
     
    Exclusive Group Training Project Management Methodologies with MS. Project 2010 PT.ANTAM

    Pelatihan Project Management Methodologies with MS. Project 2010 bersama 6 peserta Exclusive Group dari PT. ANTAM, Tbk. (Aneka Tambang) Sulawesi Tenggara
    Training ini membahas konsep Project Management beserta metodologi yang diimplementasikan menggunakan MS. Project , pembahasan teori berupa Konsep CPM, PDM, Earned Value (BCWS, SV, CV, SPI dll) Juga dibahas untuk memberi bekal mendalam perihal Project Management.
    disertai pembahasan studi kasus
    Kurva S

Android JQuery Mobile , Introduction

 JQueryMobile (JQM)

(Mengenal Jquery Mobile Framework )

jQuery Mobile is built on top of the jQuery library, which makes it easy to learn if you already know jQuery.

It uses HTML5, CSS3, JavaScript and AJAX to accomplish its work for laying out pages with minimal scripting.
Why Use jQuery Mobile?

jQuery Mobile takes the "write less, do more" to a new level: It automatically design web pages with an attractive and "easy-to-use" look, that will work the same way on all mobile devices.

Note     Instead of writing one application for each mobile device or OS:

    Android and Blackberry is written in Java

    iOS is written in Objective C

    Windows Phone is written in C# and .net, etc.

jQuery Mobile solves this problem, as it only uses HTML, CSS and JavaScript, which is standard for all mobile web browsers!

Best Reading Experience

Even though jQuery Mobile works on all mobile devices, it may have some compatibility issues on desktop computers (due to limited CSS3 support).

Excel VBA, Prevent Case Sensitive with Ucase function

Ucase Function

 (Menangani case sensitif dengan function Ucase Excel VBA)

The Ucase function can compare text in a range of cells, allowing us to write a macro that compares text case-insensitively.

Here is one that displays a message box if it encounters any cell in A1:A10 of the active sheet containing any case variation of the word CAT.

The code.
To insert the code, press Alt/Option-F11, select Insert → Module, and paste the following:

Sub CompareText( )
Dim rCell As Range

    For Each rCell In Range("A1:A10")
    If UCase(rCell) = "CAT" Then
        MsgBox rCell.Address & " has " & rCell & " in it"
    End If
    Next rCell
End Sub

Exit the VBE and return to Excel and save your workbook.

To run the macro, select Developer → Macros (pre-2007, Tools → Macro → Macros...), select CompareText from the list, and click Run. So if you had the word CAT (uppercase) in cells A1:A9 and the word cat (lowercase) in A10, the macro would display a message box for each instance of the word "cat," regardless of what case it is entered in.

Excel VBA , Variable Tutorial

Variables in Excel VBA



(Mengenal dan menggunakan Variable di Excel VBA)


Integer    |   String    |   Double    |   Boolean

This tutorial teaches you how to declare, initialize and display a variable in Excel VBA. Letting Excel VBA know you are using a variable is called declaring a variable. Initializing simply means assigning a beginning (initial) value to a variable.

Place a command button on your worksheet and add the code lines below. To execute the code lines, click the command button on the sheet.

Integer


Integer variables are used to store whole numbers.
Dim x As Integer
x = 6
Range("A1").Value = x



Explanation: the first code line declares a variable with name x of type Integer. Next, we initialize x with value 6. Finally, we write the value of x to cell A1.

String


String variables are used to store text.

Code:
Dim book As String
book = "bible"
Range("A1").Value = book



Explanation: the first code line declares a variable with name book of type String. Next, we initialize book with the text bible. Always use apostrophes to initialize String variables. Finally, we write the text of the variable book to cell A1.

Double


A variable of type Double is more accurate than a variable of type Integer and can also store numbers after the comma.

Code:
Dim x As Integer
x = 5.5
MsgBox "value is " & x




Result is Not Accurate Enough

But that is not the right value! We initialized the variable with value 5.5 and we get the value 6. What we need is a variable of type Double.

Code:
Dim x As Double
x = 5.5
MsgBox "value is " & x




Note: Long variables have even larger capacity. Always use variables of the right type. As a result, errors are easier to find and your code will run faster.

Boolean


Use a Boolean variable to hold the value True or False.

Code:
Dim continue As Boolean
continue = True

If continue = True Then MsgBox "Boolean variables are cool"




Explanation: the first code line declares a variable with name continue of type Boolean. Next, we initialize continue with the value True. Finally, we use the Boolean variable to only display a MsgBox if the variable holds the value True.

Excel VBA , Range Object, Cells, Rows, Columns, Copy , count Tutorial

Range Object Refferences


(Mengenal Object Range di Excel VBA Macro)

Range Examples | Cells | Declare a Range Object | Select | Rows | Columns | Copy/Paste | Clear | Count
The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA. This chapter gives an overview of the properties and methods of the Range object. Properties are something which an object has (they describe the object), while methods do something (they perform an action with an object).
Range Examples

Place a command button on your worksheet and add the following code line:
Range("B3").Value = 2



Excel VBA Range Example


Code:
Range("A1:A4").Value = 5



Range Example


Code:
Range("A1:A2,B3:C4").Value = 10


Cells


Instead of Range, you can also use Cells. Using Cells is particularly useful when you want to loop through ranges.

Code:
Cells(3, 2).Value = 2



Cells in Excel VBA


Explanation: Excel VBA enters the value 2 into the cell at the intersection of row 3 and column 2.

Code:
Range(Cells(1, 1), Cells(4, 1)).Value = 5


Declare a Range Object


You can declare a Range object by using the keywords Dim and Set.

Code:
Dim example As Range
Set example = Range("A1:C4")

example.Value = 8


Select


An important method of the Range object is the Select method. The Select method simply selects a range.

Code:
Dim example As Range
Set example = Range("A1:C4")

example.Select



Rows


The Rows property gives access to a specific row of a range.

Code:
Dim example As Range
Set example = Range("A1:C4")

example.Rows(3).Select




Columns


The Columns property gives access to a specific column of a range.

Code:
Dim example As Range
Set example = Range("A1:C4")

example.Columns(2).Select




Copy/Paste


The Copy and Paste method are used to copy a range and to paste it somewhere else on the worksheet.

Code:
Range("A1:A2").Select
Selection.Copy

Range("C3").Select
ActiveSheet.Paste




Although this is allowed in Excel VBA, it is much better to use the code line below which does exactly the same.
Range("C3:C4").Value = Range("A1:A2").Value
 

Clear


To clear the content of an Excel range, you can use the ClearContents method.
Range("A1").ClearContents

or simply use:
Range("A1").Value = ""

Note: use the Clear method to clear the content and format of a range. Use the ClearFormats method to clear the format only.

Count


With the Count property, you can count the number of cells, rows and columns of a range.

Count Property

Note: border for illustration only.

Code:
Dim example As Range
Set example = Range("A1:C4")

MsgBox example.Count




Count Cells


Code:
Dim example As Range
Set example = Range("A1:C4")

MsgBox example.Rows.Count



Count Rows


Note: in a similar way, you can count the number of columns of a range.

Excel VBA , Loop Tutorial

Excel VBA Macro Tutorial , How to use Loop


Single Loop    |   Double Loop    |   Triple Loop    |   Do While Loop


Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.
Single Loop

You can use a single loop to loop through a one-dimensional range of cells.


Place a command button on your worksheet and add the following code lines:

Dim i As Integer

For i = 1 To 6
    Cells(i, 1).Value = 100
Next i




Single Loop in Excel VBA


Explanation: The code lines between For and Next will be executed six times. For i = 1, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 1. When Excel VBA reaches Next i, it increases i with 1 and jumps back to the For statement. For i = 2, Excel VBA enters the value 100 into the cell at the intersection of row 2 and column 1, etc.

Note: it is good practice to always indent (tab) the code between the words For and Next. This makes your code easier to read.
Double Loop

You can use a double loop to loop through a two-dimensional range of cells.

Place a command button on your worksheet and add the following code lines:
Dim i As Integer, j As Integer

For i = 1 To 6
    For j = 1 To 2
        Cells(i, j).Value = 100
    Next j
Next i




Double Loop in Excel VBA


Explanation: For i = 1 and j = 1, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 1. When Excel VBA reaches Next j, it increases j with 1 and jumps back to the For j statement. For i = 1 and j = 2, Excel VBA enters the value 100 into the cell at the intersection of row 1 and column 2. Next, Excel VBA ignores Next j because j only runs from 1 to 2. When Excel VBA reaches Next i, it increases i with 1 and jumps back to the For i statement. For i = 2 and j = 1, Excel VBA enters the value 100 into the cell at the intersection of row 2 and column 1, etc.
Triple Loop

You can use a triple loop to loop through two-dimensional ranges on multiple Excel worksheets.

Place a command button on your worksheet and add the following code lines:
Dim c As Integer, i As Integer, j As Integer

For c = 1 To 3
    For i = 1 To 6
        For j = 1 To 2
            Worksheets(c).Cells(i, j).Value = 100
        Next j
    Next i
Next c


Explanation: The only change made compared to the code for the double loop is that we have added one more loop and added Worksheets(c). in front of Cells to get the two-dimensional range on the first sheet for c = 1, the second sheet for c = 2 and the third sheet for c = 3. Download the Excel file to see this result.
Advertisement
Do While Loop

Besides the For Next loop, there are other loops in Excel VBA. For example, the Do While Loop. Code placed between Do While and Loop will be repeated as long as the part after Do While is true.

1. Place a command button on your worksheet and add the following code lines:
Dim i As Integer
i = 1

Do While i < 6
    Cells(i, 1).Value = 20
    i = i + 1
Loop




Do While Loop


Explanation: as long as i is lower than 6, Excel VBA enters the value 20 into the cell at the intersection of row i and column 1 and increments i by 1. In Excel VBA (and in other programming languages), the symbol '=' means becomes. It does not mean equal. So i = i + 1 means i becomes i + 1. In other words: take the present value of i and add 1 to it. For example, if i = 1, i becomes 1 + 1 = 2. As a result, the value 20 will be placed into column A five times (not six because Excel VBA stops when i equals 6).

2. Enter some numbers in column A.


3. Place a command button on your worksheet and add the following code lines:
Dim i As Integer
i = 1

Do While Cells(i, 1).Value <> ""
    Cells(i, 2).Value = Cells(i, 1).Value + 10
    i = i + 1
Loop




Advanced Do While Loop


Explanation: as long as Cells(i, 1).Value is not empty (<> means not equal to), Excel VBA enters the value into the cell at the intersection of row i and column 2, that is 10 higher than the value in the cell at the intersection of row i and column 1. Excel VBA stops when i equals 7 because Cells(7, 1).Value is empty. This is a great way to loop through any number of rows on a worksheet.

Excel VBA Macro, Tutorial Create Function and Sub

Create Function and Sub


The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs become very useful as program size increases.
Function

If you want Excel VBA to perform a task that returns a result, you can use a function. Place a function into a module (In the Visual Basic Editor, click Insert, Module). For example, the function with name Area.

Function Area(x As Double, y As Double) As Double
Area = x * y

End Function



Explanation: This function has two arguments (of type Double) and a return type (the part after As also of type Double). You can use the name of the function (Area) in your code to indicate which result you want to return (here x * y).

You can now refer to this function (in other words call the function) from somewhere else in your code by simply using the name of the function and giving a value for each argument.

Place a command button on your worksheet and add the following code lines:

Dim z As Double

z = Area(3, 5) + 2

MsgBox z


Explanation: The function returns a value so you have to 'catch' this value in your code. You can use another variable (z) for this. Next, you can add another value to this variable (if you want). Finally, display the value using a MsgBox.

Result when you click the command button on the sheet:


Sub


If you want Excel VBA to perform some actions, you can use a sub. Place a sub into a module (In the Visual Basic Editor, click Insert, Module). For example, the sub with name Area.

Sub Area(x As Double, y As Double)

MsgBox x * y

End Sub


Explanation: This sub has two arguments (of type Double). It does not have a return type! You can refer to this sub (call the sub) from somewhere else in your code by simply using the name of the sub and giving a value for each argument.

Place a command button on your worksheet and add the following code line:

Area 3, 5

Result when you click the command button on the sheet:


Can you see the difference between the function and the sub? The function returned the value 15. We added the value 2 to this result and displayed the final result. When we called the sub we had no more control over the result (15) because a sub cannot return a value!


Excel VBA Macro, Using Date and Time, DateAdd

Tutorial Excel VBA belajar menggunakan Date and Time




Melalui module di VBE ketik script berikut

Code:

'Deklarasi variable Date dengan Dim
Dim exampleDate As Date 



'Variable diisi dengan function untuk mengambil nilai dari data tgl
exampleDate = DateValue("Jun 19, 2010")

'Test dengan melihat hasilnya di Msgbox
MsgBox Year(exampleDate)



Note: Gunakan Month dan Day untuk ambil nilai bulan dan hrii


DateAdd

Digunakan untuk mendapatkan perpanjangan hari dari tanggal yang ditentukan

Code:
'deklarasi variable
Dim firstDate As Date, secondDate As Date'Isi variable
firstDate = DateValue("Jun 19, 2010")
secondDate = DateAdd("d", 3, firstDate)
'test dengan msgbox
MsgBox secondDate



Note: Ganti d" ke  "m" untuk perpanjangan bulan dari tanggal ditentukan


current date and time, gunakan Now function.


Code:
MsgBox Now



Current Date Time
Hour, Minute, Second


Mendapatkan Jam(Hour), Gunakan Hour function.


Code:
MsgBox Hour(Now)



Time value untuk convert string ke Jam


Code:

MsgBox TimeValue("9:20:01 am")


TimeValue


Dim y As Double
y = TimeValue("09:20:01")
MsgBox y

Freelance IT Trainer, Pengajar Komputer, Inhouse Trainer, Management Trainer , Hery Purnama

Hery Purnama 081.223344.506 , Trainer Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer, Inhouse Training Certified IT Trainer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, PHP SMS Gateway, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS


Topics

  • Google Application Integration Toolbox  for web developer
    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    Web Integration with Facebook API developer toolbox
    Web Development with CMS Wordpress
    Web Development with PHP Yii Framework
    Web Development with PHP CodeIgniter
    Project Management Methodologies  With Microsoft Project 2010
    SEO and Internet Marketing
    RDBMS - Database Concept
    ITIL V.3 Foundation
    Building Database Application with Microsoft Access 2010
    Microsoft Access 2010 VBA Macro programming
    MYSQL Server DBA Fundamental
    Object Manipulation with Adobe Photoshop CS
    CorelDraw X6 for Marketing and Promotion
    Google Sketchup 3D for Building Interior
    Building Flash Animation with SWISHMAX
    Building PHP MySQL - AJAX Web Application with Adobe Dreamweaver CS
    Building  ASP.Net Application with IronSpeed Designer
    Building PHP MySQL Web Application with CodeCharge Studio
    Mobile Application Development for Android with Jquery Mobile, MySQL & Phonegap
    HTML 5 for Mobile Application Development
    Microsoft Office 2010 (WORD, EXCEL, POWERPOINT)
    Microsoft Excel Visual Basic for Application (VBA-Macro)
    Networking Essential
    Installing, Configuring and Administering Windows Server 2008
    Installing, Configuring and Administering UBUNTU
    Installing and Configuring Exchange Server 2008
    CISCO Router
    Application Programming with VB.NET
    Web and Application programming with ASP.NET
    Web and Application programming with PHP - MYSQL
    Building Rich Internet Application  with PHP and Sencha ExtJs
    Building web application with PHP MySQL & AJAX Jquery
    Building Event Scheduler System with PHP AJAX and SMS Gateway
    Computer for Secretary and Admin Staff (Networking  Essential, MS. Outlook, Document Security and sharing, MS. Office Integration, File Archive and data backup - Recovery, etc.)
    Kerio Winroute Firewall
    SQL Server 2008 Database Design & DBA Fundamental


My Clients:

  • PT. Sampoerna Tbk - Bandung
  • PT. Asuransi AXA Indonesia - Jakarta
  • Icon Plus (Icon PLN - jakarta)
  • Bank Ekonomi - Jakarta
  • PT PLN (Persero) PUSHARLIS UWP III
  • PT. Karenindo Citra Utama - Jakarta
  • ITENAS - Bandung
  • Universitas Bina Nusantara (BINUS - Jakarta)
  • Bank Jabar Banten (BJB)
  • AMDOCS - Jakarta
  • PT. Elnusa, Tbk.
  • PT. Sarana Multigriya Finansial / SMF (Persero)
  • PT. Pertamina Geothermal Energy (Thamrin - Jakarta)
  • PT. Indonesia Asahan Alumunium (INALUM- Medan)
  • UIN SUSKA - Riau
  • Rumah Sakit AWALBROS Bekasi
  • Universitas Andalas
  • Politeknik ACEH
  • Pusinfowas BPKP - Jakarta
  • Asuransi Takaful - Jakarta
  • PT. Freeport , Tbk - Tembagapura Papua
  • PT. Gerbang Sinergi Prima - Bandung
  • PT PLN (PERSERO) UIP TRANSMISI ISJ - jakarta
  • PT. CG Power System Indonesia - Bogor
  • PT. Pertamina (Persero) - Jakarta
  • Bank CIMB Niaga -  Jakarta
  • Ikatan Mahasiswa Teknik Metalurgi ITB - Bandung
  • PT. Pupuk Kijang - Cikampek
  • PT. Pertamina (Persero - Jakarta)
  • Bakrie Telecom Jakarta
  • SMKN 2 Garut
  • PT BES Kelapa Gading Jakarta
  • PT. Telkomsel - Jakarta
  • PT. Hutama Karya Persero (Bandung)
  • PT. Seascape Survey Indonesia
  • PT. Pupuk Kaltim
  • Dana Pensiun Pupuk Kaltim
  • PT. Sarinah (Persero)
  • PT. Weda Bay Nickel (Halmahera)
  • Taq-Taq Operating Company Ltd (Kurdhistan - Irak)
  • EMP MALACCA STRAIT SA - Jakarta
  • Bank BTPN Jakarta
  • PT. Sarana Multi Infrastruktur (Persero)
  • PT. Medco Energi - Jakarta
  • PT. ANTAM, Tbk.
  • Unversitas Islam Indonesia (Teknik Informatika)
  • Institut Teknologi Telkom Bandung
  • Politeknik Negeri Malang
  • PT. KPEI
  • DPPKAD Kabupaten Gresik
  • PT PJB UPHB
  • PT. Krakatau Steel



    Building Integrated Map Website with PHP MySQL and Google Map API V.3
    (Inhouse ICON PLN Jakarta)
    icon PLN inhouse sisindotek
    Inhouse Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Single Marker, Multiple marker Custom Marker , Polyline dan lainnya.
     
    Microsoft Excel Advance for Business, Accounting & Management (Bank BJB - 4 Angkatan)
    Bank BJB inhouse sisindotek
    Kegiatan inhouse training dengan Bank BJB sebanyak 4 angkatan dengan total peserta 26 orang membahas pemanfaat excel dengan tingkatan yang lebih tinggi berupa pemanfaatn formula, function baik yang sudah umum ataupun yang tidak umum untuk membuat kemudahaan dalam pengelolaan data buat kebutuhan bisnis, Akuntansi ataupun manajemen.
     
    Building Event Scheduller Application with PHP and SMS Gateway (PLN)
    Training ini kembali diikuti oleh klien exclusive group dari PT PLN (PERSERO) UIP TRANSMISI ISJ, training ini membahas cara
    membuat aplikasi Event Scheduller dengan PHP, MySQL dan SMS gateway sebagai notification systemnya
     
    Mobile Application development for Android using Jquery Mobile and Phonegap (Bakrie Telecom)
    Inhouse Training membahas pemanfaat framework JQM dan phonegap dipadukan dengan PHP Ajax untuk membuat aplikasi berbasis Android dengan mudah
     
    Project Management Methodologies with MS Project (Inhouse Training INALUM Medan)
    Inhouse Training Project Management with MS. Project bersama staff dari PT. Indonesia Asahan Alumunium (INALUM) , Training membahas konsep Project Management dan implementasinya ke dalam software MS. Project 2010, termasuk dalam pembahasan adalah Project Management Lifecycle, Cost, Budget dan metodologi seperti PERT, CPM, PDM dan juga Earned Value Concept (SV, CV, CPI, SPI, BCWS, BCWP, ACWP dll.
     
    Excel VBA Macro (Inhouse training PGE Indonesia)
    Training Excel VBA Macro Programming bersama staff dari PT. Pertamina Geothermal Energy - Jakarta, Training ini membahas pemograman
    di Excel untuk melakukan otomatisasi dan pengembangan kinerja excel untuk memenuhi kebutuhan yang lebih kompleks
     
    ITIL v3 Foundation (Exclusive Group)
    Training ITIL v.3 Foundation yang diselenggarakan di Hotel Bintang 4 (DeJava Hotel , PVJ Bandung) diikuti oleh 3 peserta dari staff PUSINFOWAS BPKP jakarta
    Training ini bertujuan memahami konsep dari pengelolaan IT berbasis layanan (IT Service Management) berdasarkan framework IT Infrastructure Library (ITIL) versi 3. Beserta tambahan skenario studi kasusnya dan implementasi menggunakan ITSM software simulation serta simulasi persiapan ujian ITIL
     
    Excel VBA Macro (Exclusive Group)
    Training Microsoft Excel Visual Basic for Application (VBA - Macro) bersama 7 peserta dari PT. Freeport , Tbk (Exclusive Group) yang terbagi atas 3 gelombang / Periode
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini. Dikarenakan paket exclusive group maka training ini juga khusus membahas kasus khusus PT Freeport untuk diterapkan di bagian planner PT Freeport sesuai kebutuhan pekerjaan.
     
    Building Integrated Map Website with PHP MySQL & Google MAP API V.3
    Training Building Integrated Map Website with PHP and Google Map API V.3 diikuti oleh peserta Exclusive Group dari PT PLN (PERSERO) UIP TRANSMISI ISJ
    Training ini membahas tentang bagaimana membuat peta digital interaktif dan dinamis dengan informasi yang koordinat / LatLong yang tersimpan di database lalu ditampilkan secara dinamis menggunakan Google MAP API V.3 , beberapa metode yang dipelajari seperti Single Marker, Multiple Marker, Polyline, Geofence, Geocode, Direction, Custom Marker dan lainnya.
     
    Inhouse Training Microsoft Excel VBA Macro
    Inhouse Training Microsoft Excel Visual Basic for Application (VBA - Macro) bersama 15 peserta dari Ikatan Mahasiswa Teknik Metalurgi ITB Bandung
    Training ini membahas Pengenalan dan pemanfaatan Macro dan pemograman VBA untuk menyempurnakan dan memaksimalkan penggunaan Microsoft Excel lebih diatas penggunaan standard pada umumnya. pengenalan objek Excel dan VBA memanipulasi objek, penggunaan control , active x , array, looping , membuat function merupakan beberapa materi yang diberikan dalam pelatihan ini.
     
    Exclusive Group Training Project Management Methodologies with MS. Project 2010 PT.ANTAM

    Pelatihan Project Management Methodologies with MS. Project 2010 bersama 6 peserta Exclusive Group dari PT. ANTAM, Tbk. (Aneka Tambang) Sulawesi Tenggara
    Training ini membahas konsep Project Management beserta metodologi yang diimplementasikan menggunakan MS. Project , pembahasan teori berupa Konsep CPM, PDM, Earned Value (BCWS, SV, CV, SPI dll) Juga dibahas untuk memberi bekal mendalam perihal Project Management.
    disertai pembahasan studi kasus
    Kurva S

Info Trainer, Pengajar Lepas SMS Gateway

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, PHP SMS Gateway, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Trainer , Pengajar PHP AJAX JQuery

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Concept, PHP , Ajax JQUERY, Yii Framework, Code Igniter, Photoshop, CorelDraw, UML, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Trainer, Pengajar Lepas Sencha ExtJS

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Freelance IT Trainer , Pengajar RDBMS Database Concept

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, RDBMS Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Freelance Trainer, Pengajar SQL Server DBA

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Freelance Trainer, Pengajar Google Sktechup 3D

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Freelance Trainer, Pengajar Oracle

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Hery Trainer/ Pengajar Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Freelance Trainer , Pengajar MS Access

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

IT Trainer , Pengajar MS Project / Manajemen Proyek

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Freelance Trainer , Pengajar Google Map API

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

IT Trainer, Pengajar Komputer ITIL foundation

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Freelance IT Trainer, Pengajar Komputer , Android Phonegap

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Trainer, Pengajar, Komputer Excel VBA Macro, Bandung, Jakarta

Hery Purnama 081.223344.506 , Jakarta, Bandung, Yogya, Indonesia, Freelance IT Trainer, Pengajar Komputer Lepas , Instruktur komputer.

Cari Pengajar , Trainer IT / Komputer untuk inhouse training di perusahaan Anda , Hubungi Hery Purnama 081223344506 , Berpengalaman lebih dari 15 tahun dan Certified

Excel VBA , Android Phonegap, Google Map API, Google Sketchup3D , MS Project, ExtJS, Oracle, SQL Server, MySQL, MS. Access VBA, Facebook API Developer dll.. Berpengalaman 15 Tahun sebagai Trainer bersertifikasi CIW, OCA, ITILF, MCP, MOS

Perancis , Hotel Murah

Wisata Eropa Perancis (paris dan kota lainnya)

Rates start from :
USD 82
IDR 803,600
Hilton Strasbourg Hotel

Star Rating : 4
Avenue Herrenschmidt
Strasbourg France
Num. Rooms : 245 , Num. Floors : 7
C-In : 3:00 PM , C-Out :

Rates start from :
USD 100
IDR 980,000
Best Western Saphir

Star Rating : 4
18 Louis Loucheur Street
Lyon 69009 France
Num. Rooms : 111 , Num. Floors : 6
C-In : 02:00PM , C-Out :11:00AM

Rates start from :
USD 0
IDR 0
Kyriad Prestige Paris Ouest Boulogne

Star Rating : 4
20-22 Rue des Abondances
Boulogne-Billancourt 92100 France
Num. Rooms : 75 , Num. Floors :
C-In : , C-Out :

Rates start from :
USD 90
IDR 882,000
61 Paris Nation Hotel

Star Rating : 4
61 Rue De La Voute
Paris 75012 France
Num. Rooms : 48 , Num. Floors : 6
C-In : 2:00 PM , C-Out :12:00 PM

Rates start from :
USD 90
IDR 882,000
Villa Eugenie Hotel

Star Rating : 4
167 Rue De Rome
Paris 75017 France
Num. Rooms : 41 , Num. Floors : 6
C-In : 2:00 PM , C-Out :12:00 PM

Rates start from :
USD 0
IDR 0
Boscolo Grand Hotel
143 Star Rating : 4
11 Rue Grolee
Lyon 69002 France
Num. Rooms : 140 , Num. Floors :
C-In : , C-Out :

Rates start from :
USD 0
IDR 0
Best Western Trianon Rive Gauche Hotel

Star Rating : 4
1 bis et 3, rue de Vaugirard
Paris 75006 France
Num. Rooms : 110 , Num. Floors :
C-In : 3:00 PM , C-Out :12:00 PM

Rates start from :
USD 94
IDR 921,200
Villa Alessandra Hotel

Star Rating : 4
9, Place Boulnois
Paris 75017 France
Num. Rooms : 49 , Num. Floors : 4
C-In : 2:00 PM , C-Out :12:00 PM

Rates start from :
USD 93
IDR 911,400
Millennium Hotel Paris Charles de Gaulle

Star Rating : 4
2 Allee du Verger, Roissy, Charles de Gaulle
Paris 95700 France
Num. Rooms : 239 , Num. Floors : 4
C-In : 12:00 PM , C-Out :12:00 AM

Rates start from :
USD 99
IDR 970,200
Quality Suites Bordeaux Airport and Spa

Star Rating : 4
83 avenue John Fitzgerald Kennedy
Merignac 33700 France
Num. Rooms : 247 , Num. Floors : 4
C-In : 12:00 PM , C-Out :12:00 AM

Rates start from :
USD 0
IDR 0
L'Hotel Pergolese

Star Rating : 4
3 rue Pergolese
Paris 75116 France
Num. Rooms : 40 , Num. Floors : 6
C-In : 02:00PM , C-Out :12:00 AM

Rates start from :
USD 100
IDR 980,000
Best Western Golf Hotel

Star Rating : 4
15 Avenue du Golf
Bussy-Saint-Georges 77600 France
Num. Rooms : 93 , Num. Floors :
C-In : 2:00 PM , C-Out :12:00 AM

Rates start from :
USD 0
IDR 0
Hotel Saint Dominique

Star Rating : 4
62 Rue Saint Dominique
Paris 75007 France
Num. Rooms : 32 , Num. Floors :
C-In : 3:00 PM , C-Out :12:00 AM

Rates start from :
USD 95
IDR 931,000
Only Suites Charles De Gaulle

Star Rating : 4
9, All�e du Verger
Paris 95700 France
Num. Rooms : 121 , Num. Floors : 5
C-In : , C-Out :12:00AM

Rates start from :
USD 93
IDR 911,400
Best Western Poitiers Centre Le Grand Hotel

Star Rating : 4
28 Carnot street
Poitiers 86000 France
Num. Rooms : 47 , Num. Floors :
C-In : 12:03 PM , C-Out :12:12 AM

Rates start from :
USD 91
IDR 891,800
Best Western Lyon Craponne

Star Rating : 4
26, rue du 11 Novembre 1918
Craponne 69290 France
Num. Rooms : 40 , Num. Floors : 2
C-In : 2:00 PM , C-Out :12:00 PM

Rates start from :
USD 91
IDR 891,800
Westotel Nantes Atlantique

Star Rating : 4
34 rue de la Vriere, La Chapelle-sur-Erdre
Nantes France
Num. Rooms : 300 , Num. Floors : 3
C-In : 04:00PM , C-Out :10:00 AM

Rates start from :
USD 91
IDR 891,800
Hotel America

Star Rating : 4
16 rue Notre Dame
Cannes 6400 France
Num. Rooms : 28 , Num. Floors : 4
C-In : 2:00 PM , C-Out :12:00 AM

Rates start from :
USD 78
IDR 764,400
Kyriad Prestige Toulon

Star Rating : 4
Avenue Toussaint Merle
La Seyne-sur-Mer 83500 France
Num. Rooms : 94 , Num. Floors :
C-In : 3:00 PM , C-Out :12:00 AM

Rates start from :
USD 0
IDR 0
Suite Affaire Marseille Vieux Port

Star Rating : 4
4 rue Coutellerie
Marseille 13002 France
Num. Rooms : , Num. Floors :
C-In : , C-Out :

Rates start from :
USD 0
IDR 0
Hotel Le Versailles

Star Rating : 4
7, rue Sainte Anne
Versailles 78000 France
Num. Rooms : 45 , Num. Floors : 5
C-In : 2:00 PM , C-Out :12:00 PM

Rates start from :
USD 97
IDR 950,600
Hotel Renaissance de Castres

Star Rating : 4
17 rue Victor Hugo
Castres 81100 France
Num. Rooms : 20 , Num. Floors :
C-In : :00 PM , C-Out :11:15 AM

Rates start from :
USD 0
IDR 0
Aletti Palace Hotel

Star Rating : 4
3, Place Joseph Aletti
Vichy 3200 France
Num. Rooms : 129 , Num. Floors :
C-In : , C-Out :

Rates start from :
USD 92
IDR 901,600
Zenitude Hotel Residence Colmar_Ingersheim

Star Rating : 4
18 quai de la Fecht
Ingersheim 68040 France
Num. Rooms : 100 , Num. Floors : 2
C-In : 3:00 PM , C-Out :11:00 AM

Rates start from :
USD 0
IDR 0
Best Western Diva Opera Hotel

Star Rating : 3.5
11 rue de Trevise
Paris 75009 France
Num. Rooms : 44 , Num. Floors : 6
C-In : 2:00 PM , C-Out :12:00 PM

Rates start from :
USD 96
IDR 940,800
Vallee des Vignes Chambres d�Hotes & Appartement

Star Rating : 3.5
29 route de Thesee
Monthou-sur-Cher 41400 France
Num. Rooms : 5 , Num. Floors : 1
C-In : 5:00 PM , C-Out :11:00 AM

Rates start from :
USD 89
IDR 872,200
Grand Hotel de Turin

Star Rating : 3
6 rue Victor Masse
Paris 75009 France
Num. Rooms : 20 , Num. Floors : 6
C-In : 14:00AM , C-Out :11:00AM

Rates start from :
USD 88
IDR 862,400
Hotel Trinite Plaza

Star Rating : 3
41, rue Jean-Baptiste Pigalle
Paris 75009 France
Num. Rooms : 42 , Num. Floors : 5
C-In : 14:00PM , C-Out :12:00AM

Rates start from :
USD 63
IDR 617,400
Best Western New York Nice

Star Rating : 3
44 avenue du Marchal Foch
Nice 6000 France
Num. Rooms : 50 , Num. Floors :
C-In : , C-Out :

Rates start from :
USD 83
IDR 813,400
Hotel Villa D'Est
Villa D'est Hotel Star Rating : 3
12 Rue Jacques Kabl�
Strasbourg 67000 France
Num. Rooms : 46 , Num. Floors : 5
C-In : 15:00 PM , C-Out :12:00AM