SenneVL seems to have shown something that should work in powershell, however I am not as clued up in powershell as i'd like to be, can you explain the script So back to my original question, can someone help me make a script which does what I am after. it would appear that robocopy can only accept a min/max age in whole days which Yes it might have to iterate through all the folders and be slower, but my original question was very specific to the date and time, those dates and times are there for a reason. VB script has the ability to use the FSObject and create folder directories in the same structure as another I am fairly sure of that. I thought I was correct the first time I posted this - a script to perform the copying. Get-ChildItem $StrSource | Where-Object | Copy-Item -Destination $StrTarget $EndDate = (get-date -year 2011 -month 6 -day 4) Or in Powershell: $StartDate = (get-date -year 2011 -month 6 -day If you persist scripting this yourself, you will have to have an handle to the source folder and loop through all files. Wscript.echo 'Robocopy returned code ' & intreturn StrCommand='robcopy.exe ' & StrMySource & ' ' & StrMyTarget & ' /S /MaxAge:5' For one, robocopy will perform significantly better than any script, secondly robocopy is certainly better tested and debugged than any of your own code. I would not recommend scripting what is already available. function main(workbook: ExcelScript.You can call robocopy from within a script. An ExcelScript.Workbook should always be the first parameter. When the function runs, the Excel application invokes the main function by providing the workbook as its first parameter. Main function: The script's starting pointĮach script must contain a main function with the ExcelScript.Workbook type as its first parameter. The TypeScript documentation on object types, type inference, and type compatibility will be the most useful. TypeScript builds on JavaScript by ensuring at compile-time that the right types are used for method calls and assignments.

Mozilla offers a good, comprehensive tutorial on JavaScript. You should feel comfortable with concepts like variables, control flow, functions, and data types.

The following resources can help you understand the coding side of Office Scripts. We recommend you have some beginner-level programming knowledge before starting your Office Scripts coding journey. If you're familiar with JavaScript, your knowledge will carry over because much of the code is the same in both languages. Office Scripts are written in TypeScript, which is a superset of JavaScript. TypeScript: The language of Office Scripts

You'll learn how the Excel objects work together and how the Code Editor synchronizes with a workbook. This article will introduce you to the technical aspects of Office Scripts.

Is there a copy of the office script