Windows文件打开/保存常用对话框

问题描述

我使用这个Access Cookbook来自Ken Getz，它附带了一些非常好的示例代码和应用程​​序。


我使用了一些文件打开的功能，但我不知道他们创造了什么只使用我想要的部分。


我正在尝试使用Windows文件打开类型对话框来识别目录，然后将该目录作为字符串返回到最终的函数处理该文件中的所有excel电子表格，并选择要附加到我的Access数据库中的表格的特定数据。


我似乎要沿着两条路径之一走下去...要么使用FileDialog对象或Windows API直接。我只是不知道我需要做什么才能把目录归还给我。


提前感谢您的帮助！

I use this "Access Cookbook" from Ken Getz that comes with some pretty nice sample code and applications.

I use some file open features they have but I don''t know enough about what they''ve created to use just the parts I want.

I''m trying to use the Windows File Open type dialogue to identify a directory and then return that directory as a string to a function that will ultimately process all the excel spreadsheets in that file and select specific data to append to a table in my Access DB.

I seem to be going down one of 2 paths... either using the FileDialog object or the Windows API drectly. I just don''t know what I need to do to get the directory returned to me.

Thanks in advance for any help!

推荐答案

谢谢斯科特！这是代码。

表单上有一个click on click，它调用一个函数，该函数又调用下面的另一个函数

Thanks Scott! Here''s the code.

The form has this on click sub that calls a function which in turn calls another function below

展开 | 选择 | Wrap | 行号

这篇关于Windows文件打开/保存常用对话框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！