Archiving .XLS Sheets
 

It could be anything.

You use WB.Saveas, fldnm and f.name.

You may want to post what's in those variables.





mike wrote:

Hi,

I wrote a VBA code that auto archives my spreadsheets once Im done
extracting the information - but for some reason it is failing. I pasted the
code below. Anyone know why?

Code:

---

WB.SaveAs fldnm & "\Archive\" & f.Name

---

--

Dave Peterson