在受保护的Excel中获取模块的内容 [英] Get the content of the module within a protected excel

问题描述

我想在一个我已经知道密码的受保护的excel中读取模块的内容.

我实现了这样打开excel:

I wanna Read the content of the module within a protected excel which i already knew the password.

I achieved to open the excel like this:

LoExcel = CreateObject("Excel.Application")
LoWorkBook = LoExcel.WorkBooks.Open(fileName:=FilesName(0), password:="")

接下来，我该如何获取代码?

不管您留下什么，都一样.

Next,how can i get the code?

Whatever you leave,thx all the same.

推荐答案

我今天早上一直在看这个问题，由于返回信任错误而无法访问vba项目. .

您可能需要查看底部的链接，以查看是否可以解决此问题.

我有一种感觉，尽管除非原始模块已经过代码签名，否则可能无法实现.可以通过这种方式来防止病毒自我复制到其他文档中.

http://www.cpearson.com/excel/vbe.aspx [

I have been looking at this question this morning, and had difficulties with accessing the vba project as it returns a trust error.

You may want to look at the link at the bottom, to see if you can figure out a way round this.

I have a feeling though that unless the original modules have been code signed then it may not be possible. It may be done this way to prevent a virus from self replicating into other documents.

http://www.cpearson.com/excel/vbe.aspx[^]

这篇关于在受保护的Excel中获取模块的内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！