PERSONAL.XLSB
in [Programming]
|
Prev: counting values in a column
Next: Sum up values in each column in 12 different worksheets and display value in a MsgBox
From: Joe on 16 Feb 2010 21:55 Hi I have the following problem... I recorded I macro and chose to save in the Personal macro workbook. After closing and saving the files, a file named PERSONAL.XLSB is found in the path C:\Documents and Settings\<username>\Dados de aplicativos\Microsoft\Excel\XLIN�CIO I'm using the EXCEL 2007 Brazilian Portuguese version. The problem: opening Excel, the PERSONAL.XLSB file is NOT opened automatically, as should be. How can I fix this problem? Thanks in advance for your anwser. Joe
From: Peter T on 17 Feb 2010 05:01 I only have English Excel, not sure but look at this key in the registry HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\Xlstart The value I have is XLSTART which is what I'd expect in my English version, but you should have XLIN�CIO. If not try changing it (but be sure you can restore the previous setting if necessary). If that works you will also want to ensure the path is in a Trusted Location. Excel Options/Trust Center/Trusted Locations You can also look in the registry HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Trusted Locations\ Ah but if you only have an XLSB that might not be necessary (unusual, normally XLSM to store macros) Regards, Peter T "Joe" <j.l.pires(a)uol.com.br> wrote in message news:%2348Giy3rKHA.1476(a)TK2MSFTNGP02.phx.gbl... > Hi > > I have the following problem... > > I recorded I macro and chose to save in the Personal macro workbook. > > After closing and saving the files, a file named PERSONAL.XLSB is found in > the path > > C:\Documents and Settings\<username>\Dados de > aplicativos\Microsoft\Excel\XLIN�CIO > > I'm using the EXCEL 2007 Brazilian Portuguese version. > > The problem: opening Excel, the PERSONAL.XLSB file is NOT opened > automatically, as should be. > > How can I fix this problem? > > Thanks in advance for your anwser. > > Joe >
From: Joe on 17 Feb 2010 07:16 Hi Peter Thanks for your help. The entries in the Registry has the values expected, as you had mentioned. I also don't kwow why there is a XLSB file instead of a XLSM. I opened the Personal.XLSB and then I saved it as a XLSM, keeping the file attribute to hidden: it works! Any file I put in the folder is opened, as should be. I think this is a BUG of this Brazilian Portuguese version. Do you know how this can be reported to Microsoft? Thanks again. Joe "Peter T" <peter_t(a)discussions> escreveu na mensagem news:%23WIAdg7rKHA.3408(a)TK2MSFTNGP06.phx.gbl... >I only have English Excel, not sure but look at this key in the registry > > HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\Xlstart > > The value I have is XLSTART which is what I'd expect in my English > version, but you should have XLIN�CIO. If not try changing it (but be > sure you can restore the previous setting if necessary). > > If that works you will also want to ensure the path is in a Trusted > Location. > Excel Options/Trust Center/Trusted Locations > > You can also look in the registry > HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Trusted > Locations\ > > Ah but if you only have an XLSB that might not be necessary (unusual, > normally XLSM to store macros) > > Regards, > Peter T > > "Joe" <j.l.pires(a)uol.com.br> wrote in message > news:%2348Giy3rKHA.1476(a)TK2MSFTNGP02.phx.gbl... >> Hi >> >> I have the following problem... >> >> I recorded I macro and chose to save in the Personal macro workbook. >> >> After closing and saving the files, a file named PERSONAL.XLSB is found >> in the path >> >> C:\Documents and Settings\<username>\Dados de >> aplicativos\Microsoft\Excel\XLIN�CIO >> >> I'm using the EXCEL 2007 Brazilian Portuguese version. >> >> The problem: opening Excel, the PERSONAL.XLSB file is NOT opened >> automatically, as should be. >> >> How can I fix this problem? >> >> Thanks in advance for your anwser. >> >> Joe >> > >
From: Peter T on 17 Feb 2010 08:17 Hi Joe, I could report a bug for you, however I very much doubt it is a bug. Why - if it was a bug we would have seen hundreds of similar reports, but this is the first time I have heard of your problem (OK I'm sure you are not the only one). First of all Personal does indeed get saved by default as XLSB, even with macros. I still use my old Personal.xls, so I never noticed. I suggest you start again - drag all modules from your Personal into a new workbook and save it Close Excel Rename XLIN�CIO to say XLIN�CIOtmp Make a new Personal, start recording a macro, in the dialog which asks you where you want to store the macro select Personal. Do something, say select B2 and stop recording. Close Excel At the prompt allow Excel to save Personal (don't save it yourself) Re-Open Excel Hopefully your Personal will open, if it does delete that macro and re-import your old modules. If it doesn't.... did Excel create a new XLIN�CIO folder with Personal saved inside it? Regards, Peter T "Joe" <j.l.pires(a)uol.com.br> wrote in message news:usPpRs8rKHA.6140(a)TK2MSFTNGP05.phx.gbl... > Hi Peter > > Thanks for your help. > > The entries in the Registry has the values expected, as you had mentioned. > > I also don't kwow why there is a XLSB file instead of a XLSM. > > I opened the Personal.XLSB and then I saved it as a XLSM, keeping the file > attribute to hidden: it works! > > Any file I put in the folder is opened, as should be. > > I think this is a BUG of this Brazilian Portuguese version. > > Do you know how this can be reported to Microsoft? > > Thanks again. > > Joe > > > > > > > > "Peter T" <peter_t(a)discussions> escreveu na mensagem > news:%23WIAdg7rKHA.3408(a)TK2MSFTNGP06.phx.gbl... >>I only have English Excel, not sure but look at this key in the registry >> >> HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\Xlstart >> >> The value I have is XLSTART which is what I'd expect in my English >> version, but you should have XLIN�CIO. If not try changing it (but be >> sure you can restore the previous setting if necessary). >> >> If that works you will also want to ensure the path is in a Trusted >> Location. >> Excel Options/Trust Center/Trusted Locations >> >> You can also look in the registry >> HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Trusted >> Locations\ >> >> Ah but if you only have an XLSB that might not be necessary (unusual, >> normally XLSM to store macros) >> >> Regards, >> Peter T >> >> "Joe" <j.l.pires(a)uol.com.br> wrote in message >> news:%2348Giy3rKHA.1476(a)TK2MSFTNGP02.phx.gbl... >>> Hi >>> >>> I have the following problem... >>> >>> I recorded I macro and chose to save in the Personal macro workbook. >>> >>> After closing and saving the files, a file named PERSONAL.XLSB is found >>> in the path >>> >>> C:\Documents and Settings\<username>\Dados de >>> aplicativos\Microsoft\Excel\XLIN�CIO >>> >>> I'm using the EXCEL 2007 Brazilian Portuguese version. >>> >>> The problem: opening Excel, the PERSONAL.XLSB file is NOT opened >>> automatically, as should be. >>> >>> How can I fix this problem? >>> >>> Thanks in advance for your anwser. >>> >>> Joe >>> >> >> > >
From: Joe on 17 Feb 2010 19:59
Hi Peter Let me explain what I am doing. I work as instructor and developer of solutions based in MS Office. I'm reformulating a Excel VBA course and its manual. As I've been working for more than 15 years with this products. So, as I'm rewriting the manual, I have to be sure if the Practice match the Theory. Then, here we are. ------------------ I did what you asked, although I had already done. I have the two versions in my computer: 2003 and 2007. For version 2003, in brazilian portuguese version, the folder name is XLINICIO instead of XLSTART. For version 2007, the folder name is XLIN�CIO (with the acute accent), instead of XLSTART. I renamed the both folders and did the tests... Excel 2003: I recorded a macro, closed Excel and saved the file. A folder named XLINICIO was created within a file named PESSOAL.XLS. Runnin Excel 2003, a empty pattern workbook is opened and the file PESSOAL.XLS is already opened and remains hidden. As it should be. Doing the same for Excel 2007... A folder named XLIN�CIO was created within a file named PERSONAL.XLSB. Runnin Excel 2007, a empty pattern workbook is opened and nothing more occurs. The file PERSONAL.XLSB is not opened. The Trust Center is correctly configured. By renaming the file PERSONAL.XLSB to PESSOAL.XLSB, running Excel, the file is opened and remains hidden BUT no empty pattern workbook is available. The Excel window remains gray (empty). So the file PESSOAL.XLSB is considered as a common file. By just renaming the file PERSONAL.XLSB to PERSONAL.XLSM, an error message is shown informing that the file format or the extension is not correct. --- So, my conclusion at this point is that we have a bug in the brazilian portuguese version. In the following weeks I will try to make tests in computers in another environment, with another version installed. I will sinalize the result. If you have another orientation, please let me know. Thanks again for your help. Joe "Peter T" <peter_t(a)discussions> escreveu na mensagem news:uamI9N9rKHA.4360(a)TK2MSFTNGP05.phx.gbl... > Hi Joe, > > I could report a bug for you, however I very much doubt it is a bug. Why - > if it was a bug we would have seen hundreds of similar reports, but this > is the first time I have heard of your problem (OK I'm sure you are not > the only one). > > First of all Personal does indeed get saved by default as XLSB, even with > macros. I still use my old Personal.xls, so I never noticed. > > I suggest you start again - > drag all modules from your Personal into a new workbook and save it > Close Excel > Rename XLIN�CIO to say XLIN�CIOtmp > Make a new Personal, > start recording a macro, in the dialog which asks you where you want to > store the macro select Personal. > Do something, say select B2 and stop recording. > Close Excel > At the prompt allow Excel to save Personal (don't save it yourself) > Re-Open Excel > Hopefully your Personal will open, if it does delete that macro and > re-import your old modules. > If it doesn't.... > did Excel create a new XLIN�CIO folder with Personal saved inside it? > > Regards, > Peter T > > > "Joe" <j.l.pires(a)uol.com.br> wrote in message > news:usPpRs8rKHA.6140(a)TK2MSFTNGP05.phx.gbl... >> Hi Peter >> >> Thanks for your help. >> >> The entries in the Registry has the values expected, as you had >> mentioned. >> >> I also don't kwow why there is a XLSB file instead of a XLSM. >> >> I opened the Personal.XLSB and then I saved it as a XLSM, keeping the >> file attribute to hidden: it works! >> >> Any file I put in the folder is opened, as should be. >> >> I think this is a BUG of this Brazilian Portuguese version. >> >> Do you know how this can be reported to Microsoft? >> >> Thanks again. >> >> Joe >> >> >> >> >> >> >> >> "Peter T" <peter_t(a)discussions> escreveu na mensagem >> news:%23WIAdg7rKHA.3408(a)TK2MSFTNGP06.phx.gbl... >>>I only have English Excel, not sure but look at this key in the registry >>> >>> HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\Xlstart >>> >>> The value I have is XLSTART which is what I'd expect in my English >>> version, but you should have XLIN�CIO. If not try changing it (but be >>> sure you can restore the previous setting if necessary). >>> >>> If that works you will also want to ensure the path is in a Trusted >>> Location. >>> Excel Options/Trust Center/Trusted Locations >>> >>> You can also look in the registry >>> HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Trusted >>> Locations\ >>> >>> Ah but if you only have an XLSB that might not be necessary (unusual, >>> normally XLSM to store macros) >>> >>> Regards, >>> Peter T >>> >>> "Joe" <j.l.pires(a)uol.com.br> wrote in message >>> news:%2348Giy3rKHA.1476(a)TK2MSFTNGP02.phx.gbl... >>>> Hi >>>> >>>> I have the following problem... >>>> >>>> I recorded I macro and chose to save in the Personal macro workbook. >>>> >>>> After closing and saving the files, a file named PERSONAL.XLSB is found >>>> in the path >>>> >>>> C:\Documents and Settings\<username>\Dados de >>>> aplicativos\Microsoft\Excel\XLIN�CIO >>>> >>>> I'm using the EXCEL 2007 Brazilian Portuguese version. >>>> >>>> The problem: opening Excel, the PERSONAL.XLSB file is NOT opened >>>> automatically, as should be. >>>> >>>> How can I fix this problem? >>>> >>>> Thanks in advance for your anwser. >>>> >>>> Joe >>>> >>> >>> >> >> > > |