+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Raven
    Guest

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

    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.


  2. #2
    NickHK
    Guest

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

    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

    "Raven" <[email protected]> wrote in message
    news:[email protected]...
    > 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 Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1