If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
how can I specific a folder with wildcard criteria and excel willimport all the correct files in that folder?
You have a response at your other post in .excel
Raven wrote: 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. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complex query criteria - desperate appeal | Ted Allen | Running & Setting Up Queries | 5 | November 17th, 2004 06:14 PM |
Combining difficult Excel files | hamed_gan | General Discussion | 1 | November 8th, 2004 11:40 AM |
DSUM Criteria and Excel Help | Earl Kiosterud | Worksheet Functions | 2 | April 30th, 2004 07:55 PM |