PDA

View Full Version : How to RAR a folder via VBA?



Erdin? E. Ka
05-21-2007, 05:00 AM
Hi everyone, :hi:

I want to get a WinRAR of a specific folder via VBA.

Sample Path Name is:
"C:\SampleFolder"

I want to get some kind of backup my files into SampleFolder:
"SampleFolder_2007_05_21_14_54_15.rar"
( I want to save it in the "C:\MyBackups" folder. )

Descriptions:
SampleFolder = Folder Name
2007 = Year value of Windows's Current Calendar
05 = Month value of Windows's Current Calendar
21 = Day value of Windows's Current Calendar
14 = Hour value of Windows's Current Calendar
54 = Minute value of Windows's Current Calendar
15 = Second value of Windows's Current Calendar

Thank you very muh.

Bob Phillips
05-21-2007, 06:04 AM
If you can do WinZip, Ron has some code at http://www.rondebruin.nl/windowsxpzip.htm