#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 246
Default xlsm

Good Morning,
An easy question to start the week:
Any disadvantages to saving all Excel files as xlsm, rather than xlsx?

Regards,
Jason.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default xlsm

If you have no VBA code, then the two types are essentially the same. An
XLSX cannot store VBA code. If you do have VBA code, you need to save as
XLSM.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

"WhytheQ" wrote in message
...
Good Morning,
An easy question to start the week:
Any disadvantages to saving all Excel files as xlsm, rather than xlsx?

Regards,
Jason.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 246
Default xlsm

So really, unless it is definitely just a data sheet, I may aswell
always use xlsm (as I might want to add code later)
Thanks for the help Chip.

JasonQ


On 18 Feb, 09:33, "Chip Pearson" wrote:
If you have no VBA code, then the two types are essentially the same. An
XLSX cannot store VBA code. If you do have VBA code, you need to save as
XLSM.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
* * Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)

"WhytheQ" wrote in message

...



Good Morning,
An easy question to start the week:
Any disadvantages to saving all Excel files as xlsm, rather than xlsx?


Regards,
Jason.- Hide quoted text -


- Show quoted text -


Reply
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
linking XLSM to XLS ado Setting up and Configuration of Excel 0 April 14th 10 07:16 PM
Personal.xlsm Andy Excel Discussion (Misc queries) 11 November 11th 09 02:20 PM
what is xlsm' file Donna Excel Discussion (Misc queries) 2 January 9th 09 02:43 PM
What does the extension '.xlsm' mean bonnie Excel Discussion (Misc queries) 2 January 8th 09 08:45 PM
how can i convert .xlsm to xls vishu Excel Discussion (Misc queries) 1 May 19th 08 03:16 PM


All times are GMT +1. The time now is 02:54 AM.

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"