Problem with Excel 2007 and Personal.XLS

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
Just an idea: try saving it as Personal.XLSX in native XL 2007 format
Happy New Year
 
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!
 
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!
Click to expand...
 
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
 
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?)
 
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!)
 
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
 
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
 
Back
Top