Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default XLSM and XLSX - what's the difference?

Could someone please clarify the purpose of the new file types in
Excel 2016/365, as I'm confused.

In various web articles/posts, such as this example
http://www.askingbox.com/question/ex...-xlsm-and-xlsb
I read that xlsx does not include macros or VBA code, but xlsm does.

So, as I want to include my old macros fro Excel 2000 and also use any
new macros I might install (with help here!) I have started using
xlsm.

HOWEVER, when I open a few remaining xlsx files that I saved earlier,
I find they *do* include macros. I can run them, and I can open the
VBA Editor.

--
Terry, East Grinstead, UK
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default XLSM and XLSX - what's the difference?

Terry Pinnell wrote:

Could someone please clarify the purpose of the new file types in
Excel 2016/365, as I'm confused.

In various web articles/posts, such as this example
http://www.askingbox.com/question/ex...-xlsm-and-xlsb
I read that xlsx does not include macros or VBA code, but xlsm does.

So, as I want to include my old macros fro Excel 2000 and also use any
new macros I might install (with help here!) I have started using
xlsm.

HOWEVER, when I open a few remaining xlsx files that I saved earlier,
I find they *do* include macros. I can run them, and I can open the
VBA Editor.


If it helps, here's an example of an xlsx that supports macros and
VBE, contrary to all that I read.

https://dl.dropboxusercontent.com/u/...rosAndVBE.xlsx


--
Terry, East Grinstead, UK
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default XLSM and XLSX - what's the difference?

On Tue, 06 Sep 2016 14:57:31 +0100, Terry Pinnell
wrote:

Terry Pinnell wrote:

Could someone please clarify the purpose of the new file types in
Excel 2016/365, as I'm confused.

In various web articles/posts, such as this example
http://www.askingbox.com/question/ex...-xlsm-and-xlsb
I read that xlsx does not include macros or VBA code, but xlsm does.

So, as I want to include my old macros fro Excel 2000 and also use any
new macros I might install (with help here!) I have started using
xlsm.

HOWEVER, when I open a few remaining xlsx files that I saved earlier,
I find they *do* include macros. I can run them, and I can open the
VBA Editor.


If it helps, here's an example of an xlsx that supports macros and
VBE, contrary to all that I read.

https://dl.dropboxusercontent.com/u/...rosAndVBE.xlsx


The fine print says "supports Macros and VBE" but I don't use either.
Both XLSM and XLSX file work for me just as XLS files did 30 years
ago. I'm easily pleased!

Steve

--
Neural Network Software for Windows http://www.npsnn.com

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,182
Default XLSM and XLSX - what's the difference?

On Tue, 06 Sep 2016 14:57:31 +0100, Terry Pinnell
wrote:

Terry Pinnell wrote:

Could someone please clarify the purpose of the new file types in
Excel 2016/365, as I'm confused.

In various web articles/posts, such as this example
http://www.askingbox.com/question/ex...-xlsm-and-xlsb
I read that xlsx does not include macros or VBA code, but xlsm
does.

So, as I want to include my old macros fro Excel 2000 and also use
any new macros I might install (with help here!) I have started
using xlsm.

HOWEVER, when I open a few remaining xlsx files that I saved
earlier, I find they *do* include macros. I can run them, and I can
open the VBA Editor.


If it helps, here's an example of an xlsx that supports macros and
VBE, contrary to all that I read.

https://dl.dropboxusercontent.com/u/...rosAndVBE.xlsx


The fine print says "supports Macros and VBE" but I don't use either.
Both XLSM and XLSX file work for me just as XLS files did 30 years
ago. I'm easily pleased!

Steve


So do XLA and XLT as well as any custom extensions like myappa, myappt!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default XLSM and XLSX - what's the difference?

Not sure I follow. Are you confirming that the 'official' advice (repeated in those examples I gave) is wrong? Are you able to see the macros in my example file?


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default XLSM and XLSX - what's the difference?

Hi Terry,

Am Tue, 06 Sep 2016 09:10:29 +0100 schrieb Terry Pinnell:

Could someone please clarify the purpose of the new file types in
Excel 2016/365, as I'm confused.

In various web articles/posts, such as this example
http://www.askingbox.com/question/ex...-xlsm-and-xlsb
I read that xlsx does not include macros or VBA code, but xlsm does.

So, as I want to include my old macros fro Excel 2000 and also use any
new macros I might install (with help here!) I have started using
xlsm.

HOWEVER, when I open a few remaining xlsx files that I saved earlier,
I find they *do* include macros. I can run them, and I can open the
VBA Editor.


if you open xls files in compatibility mode they can contain macros and
you can run the macros.
If you want to convert your files to the new file system you have to
save them as xlsm or xlsb.
If you create code and then save the workbook as xlsx the code will be
deleted.


Regards
Claus B.
--
Windows10
Office 2016
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,182
Default XLSM and XLSX - what's the difference?

Not sure I follow. Are you confirming that the 'official' advice
(repeated in those examples I gave) is wrong? Are you able to see the
macros in my example file?


What I'm confirming is that you can use any file extension you want
because Excel reads its binary and so knows it's an Excel file!

Note also that if you specify template or addin filetype when saving,
Excel tries to be helpful by switch file explorer to a 'suggested'
location. You can store wherever you want so, for examle, you could
store all addin/template files in the same location as the rest of
their respective project's files...

Project1 stores all files in its folder:

C:\MyApp\
myapp.xla
myapp.xlt
myapp.chm
myapp.ini
config.dat
license.dat
\UserData\
\Plugins\

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default XLSM and XLSX - what's the difference?

Claus Busch wrote:

Hi Terry,

Am Tue, 06 Sep 2016 09:10:29 +0100 schrieb Terry Pinnell:

Could someone please clarify the purpose of the new file types in
Excel 2016/365, as I'm confused.

In various web articles/posts, such as this example
http://www.askingbox.com/question/ex...-xlsm-and-xlsb
I read that xlsx does not include macros or VBA code, but xlsm does.

So, as I want to include my old macros fro Excel 2000 and also use any
new macros I might install (with help here!) I have started using
xlsm.

HOWEVER, when I open a few remaining xlsx files that I saved earlier,
I find they *do* include macros. I can run them, and I can open the
VBA Editor.


if you open xls files in compatibility mode they can contain macros and
you can run the macros.
If you want to convert your files to the new file system you have to
save them as xlsm or xlsb.
If you create code and then save the workbook as xlsx the code will be
deleted.


Regards
Claus B.


Claus, Garry: Thanks both. Reckon I understand it now. It seems the
crucial point is that xlsm and xlsx can both RUN macros, but only xlsm
can save/store them. I've converted my few xlsx to xlsm and will use
that from now on.

--
Terry, East Grinstead, UK
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
Avoiding display msg when saving a .xlsm file to .xlsx Vasanth Excel Discussion (Misc queries) 2 June 6th 12 12:52 PM
Importing .xlsm, .xlsx with OLEDB Jeff Excel Programming 5 January 15th 10 08:48 PM
How do I set default Excel Saveas file format to xlsx not xlsx Greg Conway Setting up and Configuration of Excel 1 September 17th 08 04:19 PM
Password security problem: view of the hiden worksheet in xlsm and xlsx file !? Ivan Excel Programming 2 December 3rd 07 11:20 AM
Difference betweem *. xlsb and *.xlsm pcor Excel Discussion (Misc queries) 2 November 1st 07 04:38 PM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"