Makro Excel Ubah beberapa worksheet ke fail CSV berasingan

Option Explicit
Sub mysaver()
Dim counter As Integer
counter = 1
' counter is for the number of sheets in the workbook
Do While counter <= Worksheets.Count
' Worksheets.Count represents the total number of sheets in the workbook
On Error GoTo ErrorHandler
' go to the nominated sheet
Worksheets(counter).Activate
' and save it. Simple...
ActiveSheet.SaveAs FileName:=ActiveSheet.Name, FileFormat:=xlCSV
counter = counter + 1
Loop
MsgBox "All Sheets Saved.", , "Success"
Exit Sub

ErrorHandler:
MsgBox "Error during save - Caution!", vbCritical, "Save Errors"
Exit Sub
End Sub
  1. Pada fail excel tekan Alt dan F11 serentak
  2. Pilih Insert -> Module
  3. Pindah kod diatas
  4. Tekan Alt dan Q untuk kembali ke fail excel
  5. Tekan Alt dan F8 dan klik Run

Sumber: http://www.accountingweb.co.uk/anyanswers/macro-exporting-50-worksheets-csv-one-pass

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Kemaskini Flasplayer

update-flashplugin-nonfree --install
update-flashplugin-nonfree --status

Flash Player version installed on this system : 11.2.202.251
Flash Player version available on upstream site: 11.2.202.251
flash-mozilla.so – auto mode
link currently points to /usr/lib/flashplugin-nonfree/libflashplayer.so
/usr/lib/flashplugin-nonfree/libflashplayer.so – priority 50
/usr/lib/gnash/libgnashplugin.so – priority 10
Current ‘best’ version is ‘/usr/lib/flashplugin-nonfree/libflashplayer.so’.

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Nota pemasangan Zarafa Open Source pada Debian Squeeze 32-bit

Note: Integrasi exim4 masih lagi tidak berfungsi, sekadar menjalankan antaramuka buat masa ini
OS: Debian 6.0.6 32-bit
ZCP: 7.1.1-37812-debian-6.0-i386

Pasang pakej-pakej yang diperlukan (Apache, PHP & MySQL)
aptitude install mysql-server
aptitude install apache2-mpm-prefork libapache2-mod-php5

Ubah kebenaran untuk skrip pemasangan
chmod 755 install.sh

Laksanakan skrip pemasangan dari folder Zarafa opensource yang telah diekstrak
./install.sh

Kebanyakan soalan, cuma tekan kekunci Enter

Jika terdapat masalah dependency, guna arahan berikut
apt-get -f install

Ubah permission /var/lib/zarafa-webapp/tmp supaya boleh diakses oleh apache
chown www-data:www-data /var/lib/zarafa-webapp/tmp

Cipta pengguna pertama yang akan menjadi admin
zarafa-admin -c user1 -f 'user1' -p abc123 -e user1@mydomain.com

Mulakan semula apache
/etc/init.d/apache2 restart

Penggunaan RAM cuma 77MB (cuba bandingkannya dengan Zimbra!)

# free -m
             total       used       free     shared    buffers     cached
Mem:           502        467         34          0         53        337
-/+ buffers/cache:         77        425
Swap:          983          0        983

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Pasang VMware Player pada Debian Squeeze AMD64

  1. Muaturun installer VMware Player untuk Linux 64-bit
  2. Buka GNOME Terminal dan taip
    su -c 'sh Downloads/VMware-Player-versi.x86_64.bundle'
  3. Pilih “I Agree” dan tekan butang Next
  4. Pilih Yes jika mahu mendapat notifikasi apabila terdapat kemaskini untuk VMware Player & klik butang Next
  5. Pilih No jika tidak mahu menghantar maklumat penggunaan VMware Player anda kepada VMware & klik butang Next
  6. Klik butang Install untuk memulakan pemasangan
  7. Klik butang Close setelah proses pemasangan selesai
  8. Pergi ke menu Applications, pilih System Tools dan klik VMware Player
  9. Klik butang Accept untuk menerima perjanjian pengguna

Sekarang anda sudah boleh mula menggunakan VMware Player pada Debian Squeeze 64-bit

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Pasang Netvault Backup 8.6.3 pada Debian Squeeze

OS: Debian Squeeze 32-bit
IP: 192.168.56.101
Installer: netvault-R2012MAY21-JUNO-LinuxX86Hybrid.tar.gz

Muatnaik pakej installer Netvault Backup ke pelayan Debian
scp netvault-R2012MAY21-JUNO-LinuxX86Hybrid.tar.gz root@192.168.56.101:/root

Pasang libxp6 pada pelayan Debian
aptitud -y install libxp6

Ekstrak pakej installer
tar -xvf netvault-R2012MAY21-JUNO-LinuxX86Hybrid.tar.gz
cd netvault/
chmod +x install

Pasang Netvault Backup Server
./install

Jawab soalan seperti berikut:

Select language? [1] :

Have you read and agreed to the terms of the license?
(y = yes, n = no, d = display license) (y n d) [d] : y

Should a client or server version of NetVault be installed? (c s) [c] : s

Where should NetVault be installed? [/usr/netvault] :

Where should NetVault database be installed? [/usr/netvault/db] :

Please enter a NetVault machine name
using A-Z, a-z, _ and 0-9 [debian] :

Please enter the NetVault password for this machine:

Please confirm password:
.
.
.
Installation completed successfully

Perhatikan sama ada proses netvault telah berjalan
ps -ef| grep nv

root      1657     1  0 02:07 pts/0    00:00:00 /usr/netvault/bin/nvpmgr
root      1660  1657  0 02:07 pts/0    00:00:00 nvcmgr 2
root      1668  1657  0 02:07 pts/0    00:00:00 nvnmgr 3
root      1669  1657  0 02:07 pts/0    00:00:00 nvavp 8
root      1670  1657  0 02:07 pts/0    00:00:00 nvlogdaemon 7
root      1671  1657  0 02:07 pts/0    00:00:00 nvstatsmngr 9
root      1673  1657  0 02:07 pts/0    00:00:00 nvrepdbmngr 10
root      1674  1657  0 02:07 pts/0    00:00:00 nvmedmgr 4
root      1675  1657  0 02:07 pts/0    00:00:00 nvsched 5
root      1706  1295  0 02:08 pts/0    00:00:00 grep nv

Cuba akses dari mana-mana desktop Linux atau menggunakan MobaXterm dari desktop Windows
ssh -X root@192.168.56.101

Mulakan GUI Netvault Backup
nvgui &

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)