Hi Vasanth,

Am Wed, 6 Jun 2012 05:47:14 +0000 schrieb Vasanth:

------------------------------------------------------------------

The following feature cannot be saved in macro-free workbooks

VB Project

To continue saving as macro-free workbook click 'YES'

------------------------------------------------------------------

try:

Application.DisplayAlerts = False
ChDir "C:\My documents"
ActiveWorkbook.SaveAs Filename:= _
"C:\My documents\User report.xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Application.DisplayAlerts = True


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2