Problem with Excel 2007 and Personal.XLS

[Bill]

I just made a change to a macro file and am now getting the following
error:

"The file you are trying to open, 'Personal.XLS', is in a different
format than specified by the file extension. Verify that the file is
not corrupted and is from a trusted source before opening the file."

If I accept this error, things procede normally, but it's a PITA to
have to accept this every time I start Excel. FWIW, I've changed
macros before in Excel 2007 without seeing this error, so am not sure
what the problem might be. I've dug and dug but been able to resolve
the situation - can anyone help?

- Bill

Bill(at)AA4M(dot)Com

 

[Dave Peterson]

Shouldn't workbooks with macros have the .xlsm extension in xl2007?

 

[Bernard Liengme]

Just an idea: try saving it as Personal.XLSX in native XL 2007 format
Happy New Year

 

[Dave Peterson]

Just a note about the difference between .xlsx that Bernard suggested and the
..xlsm that I suggested.

..xlsx contains no VBA code (or xlm macro sheets)
..xlsm can contain this stuff

http://technet2.microsoft.com/Offic...0216-45eb-b6a7-957f9c510a851033.mspx?mfr=true

 

[Bill]

OK, I saved the file as Personal.XLSM and it is in the XLStart
diredtory, but Excel continues to try to open the XLS file. I've
explored the Options but have not found a place that I can specify to
Excel that it needs to use the Personal.XLSM file, not the other one.
How do I do this?

Thanks!

 

[Dave Peterson]

Move or delete the .xls file.

OK, I saved the file as Personal.XLSM and it is in the XLStart
diredtory, but Excel continues to try to open the XLS file. I've
explored the Options but have not found a place that I can specify to
Excel that it needs to use the Personal.XLSM file, not the other one.
How do I do this?

Thanks!

 

[Bill]

I moved it, now Excel opens normally but when I attempt to execute any
macro I get the message the "Personal.XLS is not found". There is
probably a simple answer here somewhere but darn if I can find it.

- Bill

 

[Ron de Bruin]

It is xlsb in 2007
http://www.rondebruin.nl/personal.htm

 

[Dave Peterson]

Shouldn't .xlsm still work ok?

I understand that .xlsm is one of those xml type files and .xlsb is just like
the binary format that xl2003 and before used.

(.xlsb should load more quickly, right?)

 

[Dave Peterson]

You'll have to reassign the macro to whatever you click on to start that macro.

Personally, I find it much easier to build toolbars (superseded in xl2007 by the
ribbon) on the fly.

Some references if you want to look at that option:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm

In xl2007, those toolbars and menu modifications will show up under the addins
tab (IIRC).

(Ron will correct me if I'm wrong!)

 

[Ron de Bruin]

Hi Dave

Excel record a xlsb file, i never test it wil a xlsm file
Correct

 

[Ron de Bruin]

In xl2007, those toolbars and menu modifications will show up under the addins

tab (IIRC).

Correct

For macros for all workbooks the OP can look at this example and save it as a add-in
http://www.rondebruin.nl/qat.htm

Or use this one (add-in)
http://www.rondebruin.nl/2007addin.htm

 

[Ron de Bruin]

For macros for all workbooks the OP can look at this example and save it as a add-in


Must be

For macros for all workbooks the OP can look at this example

 

[Dave Peterson]

Someday (2009???), I'll be using xl2007 <vbg>.

Hi Dave

Excel record a xlsb file, i never test it wil a xlsm file

Correct

 

[Bill]

Fixed! It turned out that the Personal.XLS file was in my "C:\Program
Files\ . . ." folder. I moved it to the right place deep down in my
"C:\Users\ . . ." folder and all is working fine now. Thanks everyone
for the assistance.

- Bill