Thread: Save Every Worksheet as its own Workbook
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Michael Smith Michael Smith is offline
external usenet poster
  
Posts: 77
Default Save Every Worksheet as its own Workbook

The collection Sheets(1) won't work because my sheets have already been
named....Any way to just name the file the same as the current sheet
name? Thanks


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote