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

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?

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