Thread: Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOOKS
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOOKS
Good to hear.

Gord

On Sat, 11 Aug 2007 21:45:35 GMT, "Mr BT" wrote:

I figured it out.
I added something to the end of the saveas line
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & w.Name,
FileFormat:=xlCSV, CreateBackup:=False

Reply With QuoteReply With Quote