Thread: Macro Strategy - "Peeling" Off Sheets
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chuckles123[_131_] Chuckles123[_131_] is offline
external usenet poster
  
Posts: 1
Default Macro Strategy - "Peeling" Off Sheets

I added 'newwkbk.Activate' before the SaveAs stmt.
OK?
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=57097

Reply With QuoteReply With Quote