英文:
Is it possible to code Visio's "Create from Data" data visualizer feature with VBA?
问题
在VBA中是否可能编写Visio的“从数据创建”功能？我希望Excel和Visio之间建立的链接是同步的，就像该功能本身一样。
在Visio中，我尝试录制一个宏，涉及使用“从数据创建”功能制作数据可视化，但在录制时它变得不可用。我在网上找不到任何相关信息。
英文:
Is it possible to code Visio's "Create from Data" feature into VBA? I want the link established between Excel and Visio to be synchronous, just like how the feature itself is.
In Visio, I tried recording a macro that involved using the "Create from Data" feature to make the data visualizer, but it became unavailable while I was recording. I can't find anything online about it.
答案1
得分: 1
数据可视化工具目前不提供任何API。因此，目前无法从VBA中使用它。
英文:
The data visualizer does not currently provide any API. So using it from VBA is currently not possible.
答案2
得分: 0
如果你能确定要在哪里输入数据以及在表单上按哪些按钮，那么你可以使用SendKeys来实现你想要的操作。
英文:
If you can work out what data you want entered where and which buttons to press on the form then you can use SendKeys to do what you want.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论