LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 10
Post Avoiding display msg when saving a .xlsm file to .xlsx

Hi

I am running a macro from xlsxm file and in the end i am savng the workbook as xlsx fomat . But i get the display message as

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

The following feature cannot be saved in macro-free workbooks

.VB Project


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

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


I click manually yes each time the macro is run. Is there any way to suppress the display message and save it as xlsx file.


Below is the code

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

Please help me in this issue
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing .xlsm, .xlsx with OLEDB Jeff Excel Programming 5 January 15th 10 08:48 PM
FYI Excel 2007: Saving a xlsm file with a hidden worksheet activated makes worksheet visible David G.[_3_] Excel Programming 0 August 3rd 09 07:16 PM
problem saving xlsx file mohavv Excel Discussion (Misc queries) 1 February 16th 09 09:28 PM
Password security problem: view of the hiden worksheet in xlsm and xlsx file !? Ivan Excel Programming 2 December 3rd 07 11:20 AM
saving xlsx file as xls changes currency symbols George Setting up and Configuration of Excel 0 August 6th 07 07:50 PM


All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"