how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raven - 24 Jan 2006 04:01 GMT

how can I specific a folder with wildcard criteria and excel will
import all the correct files in that folder?

I am completely new to macro programming. After doing a little research
I found out that GetOpenFilename or GetFileList may be able to do
similiar job. But I don't exactly know how to use getopenfilename and
getfilelist doesnt seem to be an valid function in exceel 2003. May you
give me a little instruction? Do you know any online library that gives
detailed explanations of most excel VBA functions?? Thanks.

Reply to this Message

NickHK - 24 Jan 2006 04:23 GMT

Raven,
Basically you can't.
If you provide the user with a dialog (or SHBrowseForFolder API) to select a
folder, you can open/process each .xls found there.
http://vbnet.mvps.org/code/browse/browseoverview.htm will get you started.

NickHK

> how can I specific a folder with wildcard criteria and excel will
> import all the correct files in that folder?
[quoted text clipped - 5 lines]
> give me a little instruction? Do you know any online library that gives
> detailed explanations of most excel VBA functions?? Thanks.

Reply to this Message