Home/ Questions/Q 1470
Next
Answered
computing
  • 2
Asked: 2021-10-21T14:23:38+00:00 In:

Solved Convert Macro Enabled Workbook To Normal Excel Workbook

  • 2

I just used some macros in my spreadsheet to paste data in visible cells.
I’d like to upload the file to other application which only accept the file .xlsx like without macros.

So how do i convert the file xlsm to xlsx so that no change in data happen due to macro script?
Highly appreciable your help in this concern.

Share

    1 Answer

    1. Best Answer
      In an earlier thread you were asking for help with pasting data into visible cells. In this thread you say “I just used some macros in my spreadsheet to paste data in visible cells.”

      Does that mean that your earlier issue has been solved?

      As far as this particular question, you can either remove the macros and save the file as a .xlsx or save the file as a .xls file which will retain the macros but not be seen as a .xlsm file. Whether the accepting application will know that that the macros are in the file is something you will have to test.

      Removing the macros and saving it an .xlsx file should solve both issues: acceptance by the other app and prevention of further changes because the macro no longer exists.

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0