对此说“是”之后Excel文件变得腐败 - “小心!文档的某些部分可能包含文档检查员无法删除的个人信息。 [英] Excel file getting corrupt after saying yes to this - "be careful! parts of your document may include personal information that can't be removed by the document inspector."

查看:378
本文介绍了对此说“是”之后Excel文件变得腐败 - “小心!文档的某些部分可能包含文档检查员无法删除的个人信息。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我编写了一个宏来打开一个excel模板,对它进行一些计算,然后SaveAs它。问题在于保存文件时我收到此通知 - 小心!文档的某些部分可能包含 <的个人信息span class =code-string>由文档检查器删除。



单击确定会在单击取消时呈现损坏的Excel文件,但不会保存文件根本没有。



虽然起初我只是通过提供路径和文件名(D:\ folder1 \ file.xlsx)来保存它,后来我尝试了它提到我在网上找到的一般信息(

 Filename:=   C:\ Data \& BookName,FileFormat:= _ 
xlNormal,Password:=
,WriteResPassword:= ,ReadOnlyRecommended:= False _
,CreateBackup:= False

),但没有收获。



我正在使用Excel 2013.



这个问题突然出现了。在代码给出完美结果之前。

任何想法是什么?



谢谢。



我尝试了什么:



我试过

文件名:=   C:\ Data \& BookName,FileFormat:= xlNormal,密码:=  ,WriteResPassword:= < span class =code-string> ,ReadOnlyRecommended:= False _ 
,CreateBackup:= False





我甚至用51替换xlNormal,但它仍然不起作用。

解决方案

现在我使用以下方式保存:





 Wbk.SaveAs文件名:=   D:\ folder \filename.xls,FileFormat:=  56 ,密码:=  ,WriteResPassword:=  ,ReadOnlyRecommended:= False,CreateBackup:= False 





56是.xls格式。现在结果工作簿没有任何大惊小怪。

Phew .. !!


I have written a macro that opens an excel template, does some calculations on it and then SaveAs "" it. Problem is while saving the file I am getting this notification - "

Be careful! Parts of your document may include personal information that can't be removed by the Document Inspector.


Clicking OK renders a corrupt excel file while clicking cancel does not save the file at all.

Though at first I was saving it by simply giving path and file name (D:\folder1\file.xlsx), later I tried it with mentioning general information I found on net(

Filename:="C:\Data\" & BookName, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False

), but with no gain.

I am using Excel 2013.

This problem arose all of a sudden. Before the code gave perfect result.
Any idea what is this?

Thanks.

What I have tried:

I tried with

Filename:="C:\Data\" & BookName, FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False



I even replaced xlNormal with 51 as I found but it still does not work.

解决方案

Now I am saving using the following way:


Wbk.SaveAs Filename:="D:\folder\filename.xls", FileFormat:=56, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False



56 is for .xls format. Now the result workbook is opening without any fuss.
Phew..!!


这篇关于对此说“是”之后Excel文件变得腐败 - “小心!文档的某些部分可能包含文档检查员无法删除的个人信息。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆