Thread: Opening Variable File Names
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
simoncohen[_7_] simoncohen[_7_] is offline
external usenet poster
  
Posts: 1
Default Opening Variable File Names

I need to write a Macro to ask for an input number (say 123) and the
open a series of workbooks based on this input - e.g. AA123.xls
AB123.xls. Can anybody please suggest some code to enable this. Thank

--
simoncohe
-----------------------------------------------------------------------
simoncohen's Profile: http://www.excelforum.com/member.php...nfo&userid=785
View this thread: http://www.excelforum.com/showthread.php?threadid=31369

Reply With QuoteReply With Quote