excel vba; s＆quot。在？
我是在VBA中编写代码以供MS访问，该代码在Excel工作表中打开并操纵范围和数据。我找到了参考库（来自工具＆gt;参考），它允许我引用excel对象（例如范围，单元格等）。现在我想取平均范围，但这通常需要使用应用程序。WorksheetFunction类这似乎不是Microsoft Excel 16.0对象库的成员。哪个参考库可以让我访问这些功能？
I am writing code in VBA for MS Access which opens and manipulates ranges and data in Excel worksheets. I've found the reference library (from Tools > References) that allow me to reference Excel objects like ranges, cells, etc. Now I want to take the average of a range but this would normally require use of the Application.Worksheetfunction class which does not seem to have been a member of the Microsoft Excel 16.0 Object Library. Which reference library would give me access to these functions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这是我在Excel中用于VBA的所有参考文献的图像。我打开了访问权限，默认情况下没有添加参考“ Microsoft Office 16.0对象库”。
单击此处查看我使用的参考列表
Here's an image of all of the references that I use for VBA in Excel. I opened Access and by default the reference "Microsoft Office 16.0 Object Library" wasn't added.
Click here to see list of references that I use