Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Active Protected View error when doing saveas CSV file to a network folder

Thread starter bacon4life
Start date Aug 20, 2014

Status: Not open for further replies.

Aug 20, 2014

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