Archiving .XLS Sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
It could be anything.

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

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




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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Post 4
Archiving single sheets form workbook 1
Strange auto-archive behaviour 1
Excel 2003 modifies XLS files without saving! 4
collate rows from several files into one new master file 1
How to filter rows data based on background color of individual cells 1
Testing if data already imported 3
Extracting xlsx data from structured Storage 0

Back
Top