I am trying to copy values from a closed workbook to active workbook. I have following code, but this one is not working. Any help in making it work will appreciated.
Sub CopyValues()Dim swb As Workbook, dwb As Workbook
Set dwb = ActiveWorkbook
Set swb = Workbooks.Open("S:\Leave...