saveAs UNC路径失败，但映射路径有效 [英] saveAs UNC path fails but mapped path works

问题描述

我下面有一些保存Excel文件的Excel VBA代码.如果我将其另存为映射驱动器，它将起作用，但是如果使用UNC路径，它将失败.我仔细检查了UNC路径，它是正确的.

I have some Excel VBA code below that saves an Excel file. It works if I save using as a mapped drive, but fails if I use a UNC path. I double-checked the UNC path and it is correct.

我得到:对象_Workbook的运行时错误'1004'方法saveAs失败"

I get: "Run-time error '1004' method saveAs of object _Workbook failed"

mappedFileName = "x:\myFile.xlsm"
uncPathFileName = "\\fileServer01\pathPart\myFile1.xlsm"
ActiveWorkbook.SaveAs mappedFileName, FileFormat:=52 
ActiveWorkbook.SaveAs uncPathFileName, FileFormat:=52 

推荐答案

好的，我不好.经过三重检查，我发现UNC路径部分的拼写错误.

OK, my bad. I upon triple checking I discovered the UNC path-part was misspelled.

这篇关于saveAs UNC路径失败，但映射路径有效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！