View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl Bowman Carl Bowman is offline
external usenet poster
 
Posts: 21
Default Write Procedure With Logic Test To Open File From Given Directory

I need to write a procedure (not sure if this is what you call it) to cause
the file "data.xls" to be opened from path "C:\data\FEB" if the month is
February (evidenced by the text "FEB" in cell L45 in worksheet "Process") and
a file with the same name to be opened from path "C:\data\MAR" if the month
is March (evidenced by the text "MAR" in cell L45 of worksheet "Process").
This may be simple for some but I don't even know where to start. Thanks!