如何使用VBA调用excel中的功能区 [英] How to call a ribbon in excel using VBA
问题描述
您好我正在尝试设置一个调度程序来自动刷新我的Excel文件,
以下是我将要执行的步骤
>我有一个excel文件存储在我的本地光盘上,它连接到数据源(TFS)
>我需要调度程序来打开excel文件,刷新它,保存并关闭
>这里要注意的是,诺曼数据>全部刷新选项在这里不起作用,因为我已连接到团队基础服务器(TFS)我需要去团队>刷新
我知道如何调用refreshall但不确定如何使用VBA调用team> refresh。有什么想法吗?
请参阅:
https://stackoverflow.com/questions/7429813/how-to-make-excel - 自动刷新-从-TFS-2010-工作项查询
Hi I'm trying to set up a scheduler to auto refresh my excel file,
Here are the steps I will be doing
> I have a excel file stored on my local disc, its connected to a data souce (TFS)
> I need the scheduler to to open the excel file, refresh it , save it and close
> Point to note here is, the norman Data>Refresh all option does not work here, since I'm connected to Team foundation server (TFS) I need to go to team>Refresh
I know to call refreshall but not sure how to call team>refresh using VBA. any thoughts?
See: https://stackoverflow.com/questions/7429813/how-to-make-excel-automatically-refresh-from-tfs-2010-workitem-query
这篇关于如何使用VBA调用excel中的功能区的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!