Solved Convert macro enabled workbook to normal excel workbook

March 26, 2016 at 01:22:43
Specs: Windows 8.1
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.


See More: Convert macro enabled workbook to normal excel workbook

Report •

#1
March 26, 2016 at 07:51:34
✔ 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.


Report •

#2
March 26, 2016 at 07:56:57
You should be able to just delete the macro, and do a Save As

First select the Developer Tab,
Select Marcos,
Select Delete macro.

Then do a Save As and select Excel Workbook
when the location window appears
it should show the filename followed by .xlsx

MIKE

http://www.skeptic.com/


Report •

#3
March 26, 2016 at 08:47:38
Yes dear.
i solved my issue with some kind of code.
Just would like to save file in .xlsx format

I will try above trick to save the file. and revert shortly


Report •

Related Solutions

#4
March 26, 2016 at 12:41:46
Actually, it's easier than Mike described.

If you try to save a workbook with macros as a .xlsx, Excel will warn you about the macros, but give you the following option:

"To continue saving as a macro free workbook, click Yes".

The code will stay in the workbook while it is still open, but once you close it and re-open the .xlsx version, the macros will be gone.

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


Report •

#5
March 26, 2016 at 12:46:31
re:" i solved my issue with some kind of code."

Do us a favor and go back to your previous thread and provide a brief explanation of how you solved the issue. A link to the code or the code itself would be nice. That way the thread will be saved in the archives with a solution that others may be able to use.

I noticed that my response to you was marked as the best answer, but it really wasn't an answer, it was more a clarification question.

Thanks!

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


Report •

#6
March 26, 2016 at 21:34:53
ok .
I tried above but little bit confusing. For this i just copy entire sheet and paste special to new file.
And save as format in xlsx to forward to my team.
Highly grateful for such a wonderful response.
And also i published the codes to previous threads for problem in pasting in visible cells.

This possible only through clarification of problem which helped my find a way to solved this.
Thanks


Report •

Ask Question