Thread: Opening a file whose name is continuously changing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tc tc is offline
external usenet poster
  
Posts: 40
Default Opening a file whose name is continuously changing
hi. i have a CSV file which i need to import on a regular basis. the
second half of the file name keeps changing eg. abcdXXXXXX where
xxxxxx is basically the date which keeps changing. can a macro be made
to automatically open this file and can this file name be split
inorder to use the date in the workbook for other purposes?
Reply With QuoteReply With Quote