Thread: How To Loop From File0001.xls To File0150.xls
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] donna.gough@hydro.com is offline
external usenet poster
  
Posts: 81
Default How To Loop From File0001.xls To File0150.xls
For j = 1 To 11
a = "File" + "0000"
b = Left(a, Len(a) - Len(j)) & j
Next j

This works.

Reply With QuoteReply With Quote