View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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