Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Set fs = CreateObject("Scripting.FileSystemObject") strSourceFolder = "Z:\SourceDocs\Status Report\Data\Input" Set r = fs.GetFolder(strSourceFolder) strDestinationFolder = "Z:\SourceDocs\Status Report\Data\Archive\Input" For Each f In r.Files fs.CopyFile strSourceFolder & "\" & f.Name, strDestinationFolder & "\" & f.Name ' The code for saving the file with a .xlsx extension should go here ' The code for saving the first sheet in a workbook called 'Output.xlsx' should go here fs.DeleteFile strSourceFolder & "\" & f.Name Next
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.