Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 10th 09, 04:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 414
Default Personal.xlsm

Several people at my company have a personal.xlsm file that stores their
Excel 2007 personal macros. My understanding is that the correct name should
be personal.xlsb. They seem to work fine. I'm not sure how this happened,
perhaps when they tried to convert them from personal.xls?

My first question is: should I change the filenames from personal.xlsm to
personal.xlsb or leave them alone? And if I should change them, should I
just rename them outside of Excel?

Thanks for any suggestions.

  #2   Report Post  
Old November 10th 09, 04:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 8
Default Personal.xlsm

My personal file has an extension of .xls. Perhaps it has to do with the
version of Excel you're using. I'm using 2003, so that may be part of it.

"Andy" wrote:

Several people at my company have a personal.xlsm file that stores their
Excel 2007 personal macros. My understanding is that the correct name should
be personal.xlsb. They seem to work fine. I'm not sure how this happened,
perhaps when they tried to convert them from personal.xls?

My first question is: should I change the filenames from personal.xlsm to
personal.xlsb or leave them alone? And if I should change them, should I
just rename them outside of Excel?

Thanks for any suggestions.

  #3   Report Post  
Old November 10th 09, 04:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default Personal.xlsm

Hi Andy

Rename it with another extension will not work
I assume your personal.xlsm is hidden

On the View tab in the window group choose UnHide
Then do a save as xlsb
On the View tab in the window group choose Hide

Then close Excel and say Yes to save the changes to your PERSONAL file.


You can find the correct location on this page
http://www.rondebruin.nl/personal.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Andy" wrote in message ...
Several people at my company have a personal.xlsm file that stores their
Excel 2007 personal macros. My understanding is that the correct name should
be personal.xlsb. They seem to work fine. I'm not sure how this happened,
perhaps when they tried to convert them from personal.xls?

My first question is: should I change the filenames from personal.xlsm to
personal.xlsb or leave them alone? And if I should change them, should I
just rename them outside of Excel?

Thanks for any suggestions.

  #4   Report Post  
Old November 10th 09, 05:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 414
Default Personal.xlsm

personal.xls is prior to excel 2007. personal.xlsb is the default extension
for 2007. We have excel 2007--so I was wondering if personal.xlsm is a
potential "problem".

I think I am going to "convert" the personal.xls by doing a save as binary
format which changes it to xlsb and then delete the personal.xlsm.

"simmerdown" wrote:

My personal file has an extension of .xls. Perhaps it has to do with the
version of Excel you're using. I'm using 2003, so that may be part of it.

"Andy" wrote:

Several people at my company have a personal.xlsm file that stores their
Excel 2007 personal macros. My understanding is that the correct name should
be personal.xlsb. They seem to work fine. I'm not sure how this happened,
perhaps when they tried to convert them from personal.xls?

My first question is: should I change the filenames from personal.xlsm to
personal.xlsb or leave them alone? And if I should change them, should I
just rename them outside of Excel?

Thanks for any suggestions.

  #5   Report Post  
Old November 10th 09, 05:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Personal.xlsm

Just be careful if you have Excel 2007 and an earlier version of Excel with
a Personal.xls.

I needed a macro for an Excel 2007 file and fogot to save the macro with the
Excel 2007 file. So, by default it saved the macro to Personal macro
workbook which in this case was Personal.xls which is not an Excel 2007 file
format. This caused Personal.xls to be completely hosed! Luckily, I had a
backup copy of Personal.xls.

So, ALWAYS have a backup copy of Personal.*

--
Biff
Microsoft Excel MVP


"Andy" wrote in message
...
Several people at my company have a personal.xlsm file that stores their
Excel 2007 personal macros. My understanding is that the correct name
should
be personal.xlsb. They seem to work fine. I'm not sure how this
happened,
perhaps when they tried to convert them from personal.xls?

My first question is: should I change the filenames from personal.xlsm to
personal.xlsb or leave them alone? And if I should change them, should I
just rename them outside of Excel?

Thanks for any suggestions.





  #6   Report Post  
Old November 10th 09, 05:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Personal.xlsm

I use the same personal.xla (an addin) on both xl2007 and xl2003. I don't save
the addin as .xlam for xl2007.

The both work fine in both environments.

I've been lazy and haven't changed my toolbar/worksheet menu modifications to
use the ribbon, but that's ok with me.

(I'd leave them alone.)

Andy wrote:

Several people at my company have a personal.xlsm file that stores their
Excel 2007 personal macros. My understanding is that the correct name should
be personal.xlsb. They seem to work fine. I'm not sure how this happened,
perhaps when they tried to convert them from personal.xls?

My first question is: should I change the filenames from personal.xlsm to
personal.xlsb or leave them alone? And if I should change them, should I
just rename them outside of Excel?

Thanks for any suggestions.


--

Dave Peterson
  #7   Report Post  
Old November 10th 09, 06:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Personal.xlsm

Welcome to the sloth club.

MyMacros.xla works fine for both 2003 and 2007

I have added a few buttons to QAT but that's as far as I go.


Gord

On Tue, 10 Nov 2009 11:49:11 -0600, Dave Peterson
wrote:

I use the same personal.xla (an addin) on both xl2007 and xl2003. I don't save
the addin as .xlam for xl2007.

The both work fine in both environments.

I've been lazy and haven't changed my toolbar/worksheet menu modifications to
use the ribbon, but that's ok with me.


  #8   Report Post  
Old November 10th 09, 06:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Personal.xlsm

Now you've done it.

Ron's gonna be mad at both of us!

Gord Dibben wrote:

Welcome to the sloth club.

MyMacros.xla works fine for both 2003 and 2007

I have added a few buttons to QAT but that's as far as I go.

Gord

On Tue, 10 Nov 2009 11:49:11 -0600, Dave Peterson
wrote:

I use the same personal.xla (an addin) on both xl2007 and xl2003. I don't save
the addin as .xlam for xl2007.

The both work fine in both environments.

I've been lazy and haven't changed my toolbar/worksheet menu modifications to
use the ribbon, but that's ok with me.


--

Dave Peterson
  #9   Report Post  
Old November 10th 09, 06:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default Personal.xlsm

Ron's gonna be mad at both of us!
You guys are smart.
I like problems <g , sometimes I think about the good and fast Excel 2000.

But I really like this easy way for 2007
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
Now you've done it.

Ron's gonna be mad at both of us!

Gord Dibben wrote:

Welcome to the sloth club.

MyMacros.xla works fine for both 2003 and 2007

I have added a few buttons to QAT but that's as far as I go.

Gord

On Tue, 10 Nov 2009 11:49:11 -0600, Dave Peterson
wrote:

I use the same personal.xla (an addin) on both xl2007 and xl2003. I don't save
the addin as .xlam for xl2007.

The both work fine in both environments.

I've been lazy and haven't changed my toolbar/worksheet menu modifications to
use the ribbon, but that's ok with me.


--

Dave Peterson

  #10   Report Post  
Old November 10th 09, 11:26 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Personal.xlsm

I have looked at that site a few times Ron.

Involves a few minutes WORK!!


Gord


On Tue, 10 Nov 2009 19:35:18 +0100, "Ron de Bruin"
wrote:

Ron's gonna be mad at both of us!

You guys are smart.
I like problems <g , sometimes I think about the good and fast Excel 2000.

But I really like this easy way for 2007
http://www.rondebruin.nl/qat.htm




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
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
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM


All times are GMT +1. The time now is 08:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017