remove all macros and forms in file and save the file as xlsx

[Alaa mg]

hi

is there macro remove all macros and forms , shapes and buttons in file XLSM and save the file as XLSX based on date(30/12/2021) .

the file should work until before this date . if I open file in 30/12/2021 then should delete all macros and forms and shapes , buttons in all the sheets

with keep the data contains value, letters ,formatting , borders ,formulas...etc ain all sheets when save the file as xlsx . but before does all what I mentioned should save the file as xlsm in this directory c:\temp just when open file in 30/12/2021 .
I hope my thread is clear .

 

[Alaa mg]

The concern is that what if no one open the file on that date due to holiday or whatever. Maybe give the time period between certain date perhaps.

so you suggest the condition should locate between two dates ?

 

[Zot]

Also if you open it from Temp on the same day it will still error

@Zot Why don't you consider using a Custom Document Property to check if file is already is processed?

remove all macros and forms in file and save the file as xlsx

I've never use it. Any advantage here to use it here since just want to save macro free file in original folder and macro version in Temp.

 

[Zot]

so you suggest the condition should locate between two dates ?

Just an option is you want to limit duration but that will keep the macro file in original work folder which you want to avoid, right?

 

[Alaa mg]

Just an option is you want to limit duration but that will keep the macro file in original work folder which you want to avoid, right?

yes

 

[Alaa mg]

@Zot can you see my request about the date ,please?