G
Guest
I distribute a file to users on the network, they enter information and then
save it back to the network. The problem is that the network is slow, so
sometimes users will save it to their C drive to work on it, and then forget
to switch back to the network when they are done. I added code to save back
to the network when they complete their processing; however, it states that
the file cannot be accessed when they are working directly off the network. I
need code that saves as to the network when working off the c drive and just
saves when working off the network.
This is what I currently have:
Application.DisplayAlerts = False
dim netwrkpath5 as string
dim branch as string
branch = Sheets("RegionalOutputFile").Range("aa2").Value
netwrkpath5 = "\\ahfctor01\ahfcsharedfiles\Branch and Corporate\BR" + branch
netwrkpath5 = netwrkpath5 + "\Region" + branch + "BARModel.xls"
ActiveWorkbook.SaveAs Filename:=netwrkpath5
Application.DisplayAlerts = True
Thanks for any help you can give!
save it back to the network. The problem is that the network is slow, so
sometimes users will save it to their C drive to work on it, and then forget
to switch back to the network when they are done. I added code to save back
to the network when they complete their processing; however, it states that
the file cannot be accessed when they are working directly off the network. I
need code that saves as to the network when working off the c drive and just
saves when working off the network.
This is what I currently have:
Application.DisplayAlerts = False
dim netwrkpath5 as string
dim branch as string
branch = Sheets("RegionalOutputFile").Range("aa2").Value
netwrkpath5 = "\\ahfctor01\ahfcsharedfiles\Branch and Corporate\BR" + branch
netwrkpath5 = netwrkpath5 + "\Region" + branch + "BARModel.xls"
ActiveWorkbook.SaveAs Filename:=netwrkpath5
Application.DisplayAlerts = True
Thanks for any help you can give!