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: Peter T on 18 Feb 2010 05:10 You have given a very detailed description but could you confirm a couple of small things which seem to be different between your 2003 & 2007 In 2003 you say the created folder is XLINICIO (without an accent) In 2007 you say the created folder is XLIN�CIO (with an acute accent) In 2003 the file is named PESSOAL.XLS In 2007 the file is named PERSONAL.XLSB This part is very strange - > Runnin Excel 2007, a empty pattern workbook is opened and nothing more > occurs. The file PERSONAL.XLSB is not opened. *All* files in the start folder should open, including PERSONAL.XLSB even if that is not truly recognized as the Personal file. But if you rename the file to PESSOAL.XLSB then it does open but as an ordinary file, hidden so you will not see any default file (this aspect makes sense if this name is not recognized as the Personal. I understand why you feel it is a bug. However if it is a bug that impacts many people I'm surprised not only I don't know about it but nobody else has confirmed in this thread. In my experience reporting as a bug to MS will not get very far unless it can be reproduced. Almost certainly the person who "triages" the report will not be able to reproduce it. Possibly there is something else about your overall setup that is causing the problem. In the meantime hopefully this workaround will enable a default workbook to open and also a file that's similar to your Personal, albeit not a truly a Personal. Name the file to anything that will open (eg PESSOAL.XLSB) and keep it in the start folder. Create a new workbook SaveAs the new workbook as a template in the start folder with the Portuguese equivalent of this name Book1.xltx Change "Book" to the Portuguese name of a default workbook, but be sure to add the "1". Regards, Peter T "Joe" <j.l.pires(a)uol.com.br> wrote in message news:eTx5fWDsKHA.3908(a)TK2MSFTNGP05.phx.gbl... > 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 >>>>> >>>> >>>> >>> >>> >> >> > > |