Can't save macro code

Hi,

I have a working macro code Thomas at EE wrote for me in fiile name "Test_6".  But I can't save into file "Test_7".

Can you please help.

Thanks.

Kathryn
Test-6.xls
Test-7.xlsx
KathrynTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DaveCommented:
That is because the xlsx file is not macro enabled

Try saving as a xlsm file (macro enabled) file type instead

Cheers

Dave
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ardhendu SarangiSr. Project ManagerCommented:
Hi Kathyrn,
since Test-7 is a plain excel file, you are not able to save the macro in it. Try saving the file as a .xlsm extension and the macro would be saved in it.

See attached
0
Ardhendu SarangiSr. Project ManagerCommented:
File with macro
Test-7.xlsm
0
zorvek (Kevin Jones)ConsultantCommented:
You have to save the 2007/2010 workbook as a macro workbook.

See attached.

Kevin
Test-7.xlsm
0
KathrynTAuthor Commented:
Thanks you all for your quick response.

I have a meeting with India in 1/2 an hour with this.

You guys are awesome.

Kathryn
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.