Thread: opening and closing files in order with vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shane[_2_] shane[_2_] is offline
external usenet poster
  
Posts: 1
Default opening and closing files in order with vba
I am wanting to open and close a excel file named PS 01-01-98 through PS 01-01-2004 in order and extract data from each file untill I reach the last file. I already have the code written to extract the data, but am not sure how to open the next filename in order. Any help would be greatly appreciated
thanks, shane
Reply With QuoteReply With Quote