Solved

vbs to compress file

Posted on 2010-11-17
3
523 Views
Last Modified: 2012-06-21
I have the code below that I obtained from EE, but it doesn't seem to work.   I want to be able to compress all the files in the "c:\prg" folder and run daily via scheduler.
strComputer = "chpcpsi.cmhhp.com"



dtmDate = Date - 1

strDay = Day(dtmDate)

If Len(strDay) < 2 Then

    strDay = "0" & strDay

End If

strMonth = Month(dtmDate)

If Len(strMonth) < 2 Then

    strMonth = "0" & strMonth

End If

strYear = Year(dtmDate)

strTargetDate = strYear & strMonth & strDay



Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")



Set FileList = objWMIService.ExecQuery _

( "ASSOCIATORS OF {Win32_Directory.Name='C:\prg'} Where " _

& "ResultClass = CIM_DataFile" )



For Each objFile In FileList

	strDate = Left(objFile.CreationDate, 8)

	If strDate < strTargetDate Then

		compress(objfile.name)

	End If

Next





MsgBox "done"







Function compress(strfile)

	Set objWMI = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")

	Set objFile = objWMI.Get("Cim_Datafile='" & strFile & "'")

	strerr = objFile.Compress

	If strerr <> 0 Then

		compress = strFile & " There was an error compressing the file: " & strerr

	Else

		compress = strfile & " File compression successful"

	End If

End Function

Open in new window

0
Comment
Question by:epicazo
  • 2
3 Comments
 
LVL 5

Expert Comment

by:KenIBrown2
Comment Utility
Im not an expert in vbs, but try using tried & tested generic debugging techniques to narrow down the problem:
If you have the ability to display message boxes etc or some other means of communicating the program's flow, choose key points and display intermediate results so you can narrow down where the problem lies ( you have not said exactly what the problem is), eg are there any files in filelist etc...
Once you know where the problem is, you can fix it and then remove the debugging stuff....
0
 

Accepted Solution

by:
epicazo earned 0 total points
Comment Utility
what I meant by "it doesn't seem to work" is that i don't see the compressed file anywhere.   I searched for it, and no luck.
0
 

Author Closing Comment

by:epicazo
Comment Utility
No suitable solution found.   Closed
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The way I use Experts Exchange to assist me in analyzing and diagnosing a problem is I first enter a Verbose Question at Experts Exchange like: Office 2007 will hang when opening and saving files I then launch WordPad (any text editor will do) an…
Many admins will agree: WSUS is is a nice invention but using it on the client side when updating a newly installed computer is still time consuming as you have to do several reboots and furthermore, the procedure of installing updates, rebooting an…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now