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

I only have English Excel, not sure but look at this key in the registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\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\E xcel\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" wrote in message
...
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

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@discussions escreveu na mensagem
...
I only have English Excel, not sure but look at this key in the registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\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\E xcel\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" wrote in message
...
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

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" wrote in message
...
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@discussions escreveu na mensagem
...
I only have English Excel, not sure but look at this key in the registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\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\E xcel\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" wrote in message
...
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

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@discussions escreveu na mensagem
...
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" wrote in message
...
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@discussions escreveu na mensagem
...
I only have English Excel, not sure but look at this key in the registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\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\E xcel\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" wrote in message
...
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

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" wrote in message
...
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@discussions escreveu na mensagem
...
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" wrote in message
...
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@discussions escreveu na mensagem
...
I only have English Excel, not sure but look at this key in the registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\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\E xcel\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" wrote in message
...
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

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

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 am 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

Previous Posts In This Thread:

On Tuesday, February 16, 2010 9:55 PM
Joe wrote:

PERSONAL.XLSB
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 am 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

On Wednesday, February 17, 2010 5:01 AM
Peter T wrote:

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 registry

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\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\E xcel\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

On Wednesday, February 17, 2010 7:16 AM
Joe wrote:

Hi PeterThanks for your help.
Hi Peter

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 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@discussions escreveu na mensagem

On Wednesday, February 17, 2010 8:17 AM
Peter T wrote:

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 is
the first time I have heard of your problem (OK I am 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 (do not 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 does not....
did Excel create a new XLIN?CIO folder with Personal saved inside it?

Regards,
Peter T

On Wednesday, February 17, 2010 7:59 PM
Joe wrote:

Hi PeterLet me explain what I am doing.
Hi Peter

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

On Thursday, February 18, 2010 5:10 AM
Peter T wrote:

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/tutorials...e-iterato.aspx

Move or delete them from your XLSTART folder.

BTW.........Personal.xls is not a worksheet................is a workbook.

I don't know what "Practice" is but I'll bet it is also a workbook.


Gord Dibben MS Excel MVP

On Wed, 14 Apr 2010 13:46:41 -0700, Barbara Moore wrote:

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

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 am 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

Previous Posts In This Thread:

On Tuesday, February 16, 2010 9:55 PM
Joe wrote:

PERSONAL.XLSB
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 am 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

On Wednesday, February 17, 2010 5:01 AM
Peter T wrote:

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 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

On Wednesday, February 17, 2010 7:16 AM
Joe wrote:

Hi PeterThanks for your help.
Hi Peter

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 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@discussions escreveu na mensagem

On Wednesday, February 17, 2010 8:17 AM
Peter T wrote:

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 is
the first time I have heard of your problem (OK I am 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 (do not 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 does not....
did Excel create a new XLIN?CIO folder with Personal saved inside it?

Regards,
Peter T

On Wednesday, February 17, 2010 7:59 PM
Joe wrote:

Hi PeterLet me explain what I am doing.
Hi Peter

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

On Thursday, February 18, 2010 5:10 AM
Peter T wrote:

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/tutorials...e-iterato.aspx