Thread: get part of a file name from a cell value for use in a macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default get part of a file name from a cell value for use in a macro
Typo

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



--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Dave" wrote in message
ups.com...
x = Cells(1, 1).Value

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



Reply With QuoteReply With Quote