Hi Pakars xl.

 

Kalau kita mau backup file excel automatis yang saya tahu pake ini.

 

 With ActiveWorkbook

 .SaveCopyAs "d:\QC link\backup.xls"

End With

 

Yang jadi masalah, back up ini untuk mem-backup workbook /file, kalau saya
hanya mau mem-backup worksheet tertentu aja gimana ya.yang ada dalam
workbook/file tersebut. Kalau boleh nih..langsung dalam bentuk *.txt. Terima
kasih banyak

 

 

Regards,

Ali 

PT. CCI Bintan

Indonesia

====================================================================
The information contained in this communication and all accompanying
documents from Coilcraft may be confidential and/or legally privileged, and
is intended only for the use of the recipient(s) named above. If you are not
the intended recipient you are hereby notified that any review, disclosure,
copying, distribution or the taking of any action in reliance on the
contents of this transmitted information is strictly prohibited. If you have
received this communication in error, please return it to the sender
immediately and destroy the original message or accompanying materials and
any copy thereof. If you have any questions concerning this message, please
contact the sender.

 

Kirim email ke