I am trying to read cell A1:A1500 on closed workbook C:\TimeCards\CivlianAlphaRoster.xls for loop info on open workbook to save as filename. I have tried for 3 days with no results.
Can someone help to see what I may be doing wrong?
Mega thanks for any help.
Short VBA is below.