Access 2007 - VBA选择外部数据功能区 [英] Access 2007 - VBA to Select External Data Ribbon

问题描述

有人可以告诉我在我的模块中使用的VBA代码来选择外部数据功能区吗？我有一个模块，它运行一些查询，并在 end 我想将查询导出到Excel。我想展示Ext。手动（或通过代码）选择已保存的导出的数据带。 （我每次都需要输入一个新的文件名）。代码行将非常感激。如果我在设置警告之前或之后做到这一点是否重要？


非常感谢！

Cele

解决方案

我不完全确定你在这里要求的是什么..你想简单地以编程方式拉出Saved Exports菜单吗？

展开 | 选择 < span class =codeDivider> | Wrap | 行号

这是完美的！正是我想做的!!非常感谢！

Cele

毕竟很容易修复=）


欢迎来到Bytes！

Can someone tell me the VBA code to use in my module to select the External Data ribbon? I have a module that runs through some queries and at the end of them I want to export the query to Excel. I would like to show the Ext. Data ribbon to manually (or by code) select "Saved Exports" (I''ll need to input a new filename each time). The line of code would be much appreciated. And would it matter if I did that before or after Setting Warning back to true?

Thanks much!
Cele

解决方案

I''m not entirely sure what you''re asking for here.. Do you wish to simply pull up the Saved Exports menu programmatically?

Expand|Select|Wrap|Line Numbers

That is perfect! Exactly what I wanted to do!! Thanks a bunch!
Cele

An easy fix after all =)

Welcome to Bytes!

这篇关于Access 2007 - VBA选择外部数据功能区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！