I do not want the worksheets Personal and Practice to open everytime I open Excel...How do you delete them?
Thanks.
Joe wrote:
PERSONAL.XLSB
16-Feb-10
H
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 i
the pat
C:\Documents and Settings\<username>\Dados d
aplicativos\Microsoft\Excel\XLIN?CI
I am using the EXCEL 2007 Brazilian Portuguese version
The problem: opening Excel, the PERSONAL.XLSB file is NOT opene
automatically, as should be
How can I fix this problem
Thanks in advance for your anwser
Joe
Previous Posts In This Thread:
PERSONAL.XLSB
H
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 i
the pat
C:\Documents and Settings\<username>\Dados d
aplicativos\Microsoft\Excel\XLIN?CI
I am using the EXCEL 2007 Brazilian Portuguese version
The problem: opening Excel, the PERSONAL.XLSB file is NOT opene
automatically, as should be
How can I fix this problem
Thanks in advance for your anwser
Joe
I only have English Excel, not sure but look at this key in the
I only have English Excel, not sure but look at this key in the registr
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\General\Xlstar
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 ca
restore the previous setting if necessary)
If that works you will also want to ensure the path is in a Truste
Location
Excel Options/Trust Center/Trusted Location
You can also look in the registr
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\Truste
Locations
Ah but if you only have an XLSB that might not be necessary (unusual
normally XLSM to store macros
Regards
Peter T
Hi PeterThanks for your help.
Hi Pete
Thanks for your help
The entries in the Registry has the values expected, as you had mentioned
I also do not 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 fil
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
Jo
"Peter T" <peter_t@discussions> escreveu na mensagem
Hi Joe,I could report a bug for you, however I very much doubt it is a bug.
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 i
the first time I have heard of your problem (OK I am sure you are not th
only one)
First of all Personal does indeed get saved by default as XLSB, even wit
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 i
Close Exce
Rename XLIN?CIO to say XLIN?CIOtm
Make a new Personal
start recording a macro, in the dialog which asks you where you want t
store the macro select Personal
Do something, say select B2 and stop recording
Close Exce
At the prompt allow Excel to save Personal (do not save it yourself
Re-Open Exce
Hopefully your Personal will open, if it does delete that macro an
re-import your old modules
If it does not...
did Excel create a new XLIN?CIO folder with Personal saved inside it
Regards
Peter T
Hi PeterLet me explain what I am doing.
Hi Pete
Let me explain what I am doing
I work as instructor and developer of solutions based in MS Office
I am reformulating a Excel VBA course and its manual
As I have been working for more than 15 years with this products.
So, as I am 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
You have given a very detailed description but could you confirm a couple
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 -
*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 am surprised not only I do not 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 is 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
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# And The Little Iterator That Could
http://www.eggheadcafe.com/tutorial...32-0ae26adaa533/c-and-the-little-iterato.aspx