使用docmd.output到Excel电子表格 [英] using docmd.outputto Excel spreadsheet
问题描述
(WindowsXP中的Microsoft Access 2007)
(Microsoft Access 2007 in WindowsXP)
我成功使用docmd.outputto根据查询创建Excel电子表格。  ;因为它是一个研究环境,所以电子表格需要受密码保护。 Access中有没有办法创建电子表格并使其密码
受保护?
I'm successfully using docmd.outputto to create an Excel spreadsheet based on a query. Because it's a research environment the spreadsheet needs to be password protected. Is there a way within Access to create the spreadsheet and make it password protected?
感谢您的帮助!
推荐答案
我想,也许,唯一的方法是"自动化" Excel,这意味着,您必须使用代码在创建Excel文件之后对其进行操作。
I think, maybe, the only way is to "automate" Excel, which means, you'll have to manipulate the Excel file, after you have created it, using code.
否则,我不确定是否有自动执行此操作的方法。
Otherwise, I am not sure there's an automatic way to do it.
只需2美分......
Just my 2 cents...
这篇关于使用docmd.output到Excel电子表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!