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
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
If (Left(BK.Name, 3)) = "NSR" Or (Left(bk.name,3) = "MAC") Then
--
Regards,
Tom Ogilvy
"GregR" <gregrivet@gmail.com> wrote in message
news:1115315909.537678.151420@z14g2000cwz.googlegroups.com...
> 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
>
Thanks again Tom
Greg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks