View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valdemar[_2_] Valdemar[_2_] is offline
external usenet poster
 
Posts: 8
Default How can macro open daily generated files?

Hi all,
please can anybody help me with xls macro? I receive on daily basis txt
files with name that contains actual date. Typically "Data_20100120.txt". I
want to use macro, open files, modify data and add them to another workbook.
That's no problem, but I don't know, how to daily open files with different
name (date).

I am not sure, how can I modify open sentence.....
Workbooks.OpenText Filename:="C:\Data_20100120.txt"
Many many thanks for your help.

Valdemar