Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal.xlsm
Right now, I spend most of my excel time in xl2003. I would imagine that when
more and more people start using xl2007 (or greater), I'll have to learn more and more about modifying the ribbon. As long as your site is there, Ron, I'll have a place to start! 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 -- 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 -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal.xlsm
Thanks so much! You are so helpful!
"Ron de Bruin" wrote: 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is xlsm' file | Excel Discussion (Misc queries) | |||
What does the extension '.xlsm' mean | Excel Discussion (Misc queries) | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) |