Backup to specific folder if workbook names begins with "NSR" or "MAC"

  • Thread starter Thread starter GregR
  • Start date Start date
G

GregR

How do I specify that I want to backup to a specific folder if the
workbook name begins with NSR or MAC, else just backup to the regular
backup folder, "BU". TIA

Greg
 
My code is failing on this line

If (Left(BK.Name, 3)) = "NSR" Or "MAC" Then

When the line is:

If (Left(BK.Name, 3)) = "NSR"

it works as intended. TIA

Greg
 

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

Back
Top