Hi Everybody,
I have been using this code on a single file
I need to to run this code on all "*.xls" files in a folder that has more than 25 files. Can this code run from the folder itself or do I always need to manually add the path.HTML Code:Sub changepass() Dim wkbook As Workbook Set wkbook = Application.Workbooks.Open("C:\test.xls", , , , "testpwd", True) 'True is required for editing the file wkbook.Password = "newpwd" wkbook.Save wkbook.Close End Sub
Kindly help
Thx-n-BR