View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael168[_49_] Michael168[_49_] is offline
external usenet poster
 
Posts: 1
Default VBA Copy Worksheets


How to copy multiple worksheets starting with worksheet's initial name
"Out1" to "Out60" to a new workbook with a new name "Out.xls" in the
vba module in one go. I want to copy the values only from old workbook
to the new workbook. The name of the old workbook is "Inventory.xls".

Thank you for the instructions.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/