Thread: get part of a file name from a cell value for use in a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_60_] Dave[_60_] is offline
external usenet poster
  
Posts: 8
Default get part of a file name from a cell value for use in a macro
x = Cells(1, 1).Value

Windows(" & x & "_122005 worksheet.xls").Activate

Reply With QuoteReply With Quote