The following feature cannot be saved in macro-free workbooks
To continue saving as macro-free workbook click 'YES'
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'
Application.DisplayAlerts = False
ChDir "C:\My documents"
ActiveWorkbook.SaveAs Filename:= _
"C:\My documents\User report.xlsx", _
Application.DisplayAlerts = True
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Copyright © 2001-2012 GNT Media