bacon4life
Electrical
I just upgraded to Excel 2013, and now one of my macros throw throws the following error when I try to save the workbook as a csv file to a network server: "Runtime error '1004' There is no active Protected View window." Anyone run into this before? This the first time in a while I have Googled something with zero results.
It seems to be related to network settings as the first line below works but the second give the error.
ActiveWorkbook.SaveAs Filename:= "C:\SynMetertest.csv" , FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= "\\Server\testfolder\SynMetertest.csv" , FileFormat:=xlCSV, CreateBackup:=False
It seems to be related to network settings as the first line below works but the second give the error.
ActiveWorkbook.SaveAs Filename:= "C:\SynMetertest.csv" , FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= "\\Server\testfolder\SynMetertest.csv" , FileFormat:=xlCSV, CreateBackup:=False
