如何创建我的导出以“将导出的文件另存为：” ？ [英] How to I create my Export to have "Save Exported File As:" ?

问题描述

我有代码，我可以将多个查询导出到一个excel工作簿，但我的代码的问题是它不会问我希望将它们导出到哪里。喜欢我的桌面或我的文档。


现在您看到的代码会自动导出到C Drive。


有谁知道我要添加到我的代码中的内容，以便在导出之前提示我要保存文件的位置？

I have codes where I can export multiple queries to one single excel workbook but the problem with my code is that it does not ask me where I would like them to be exported to. Like to my desktop or my documents.

Right now the codes which you see below exports automatically to C Drive.

Does anyone know what I have to add to my codes for it to prompt me where I would like the file to be saved before exporting?

展开 | 选择 | Wrap | 行号

推荐答案

Michele，这个场景是完美的候选者Microsoft Office文件对话框。我将发布代码以及将充分展示该概念的附件。如果您有任何问题，请随时提出。

PS - 您必须有一个参考设置Microsoft Office XX.X对象库。

Michele, this scenario is the perfect candidate for the Microsoft Office File Dialog. I''ll post the Code as well as an Attachment that will fully demonstrate the concept. Should you have any questions, feel free to ask.

P.S. - You must have a Reference set the the Microsoft Office XX.X Object Library.

展开 | 选择 | Wrap | 行号

我可能还会为这个米歇尔写一篇文章，因为它是一个经常需要的重要主题，但显然是ADezii'我已经打败了这一拳。我没有仔细检查过，但是因为它来自他，我可以告诉你（如果你已经在他已经帮助过你的其他一些线程时需要告诉你）它能够可靠地满足你当前的需要。


如果/当我收到文章完成后，我会在这里发布一个链接给它感兴趣。

I may still knock up an article for this Michelle as it''s an important subject that''s often required, but clearly ADezii''s beaten me to the punch already on this one. I haven''t checked it through in any detail, but because it comes from him I can tell you (if you even needed telling after he''s already helped you in some of your other threads) that it reliably answers your current need.

If/when I get the article finished I''ll post a link to it in here for interest.

@ NeoPa：

似乎很多人在文件/文件夹打开对话框中使用了相当复杂的API代码，在大多数情况下，这种方法更为简单（Office对话框）就是这一切。

@NeoPa:
It seems as though many individuals resort to rather complex API Code for the File/Folder Open Dialog, when, in the majority of cases, a more simplistic approach (Office Dialog) is all that is needed.

这篇关于如何创建我的导出以“将导出的文件另存为：” ？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！