Dim FSO Set objFSO = Createobject ("Scripting.FileSystemObject") strMonth = Right("0" & Month(Date), 2) strDay = Right("0" & Day(Date), 2) strYear = Year(Date) Myfile = strYear & strMonth & strDay objFSO.CopyFolder "C:\MyFile", "C:\Test\" WScript.Echo "File Copied"
|How to edit the macro code to limit the number of characters when creating worksheet tab name||5||42|
|Access VBA script to unzip a SQL Server backup file to a selected folder||12||44|
|Need help to rewrite script||3||62|
|Does anyone have a sample vb script (or vba) that opens every .xls and .xlsx file in a directory and extracts certain cells||25||68|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!