Error message

[Guest]

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 form a trusted source before opening the file. Do you want to open the
file now?? // will come up everytime new excel file is opened or xlsx file
type is open. recently reinstalled Office 2007 - it didn't fixed this issue -
any sugestions?

 

[Dave Peterson]

Shouldn't you be saving that file as personal.xlsb

http://www.rondebruin.nl/personal.htm
(from Ron de Bruin's site)

 

[Guest]

Shouldn't you be saving that file as personal.xlsb

http://www.rondebruin.nl/personal.htm
(from Ron de Bruin's site)

Marcela wrote: Hi Dave and thank you - so should i re save the personal file? i still have some old macros that i use in that format personal.xls - also this issie came up 2-3 weeks ago - i have been running Office 2007 for the past 6 months on vista and never seen this error message. and which is wierd as well - all my macros created in xlsx file format are gone.. all at once 2-3 week ago, thank you

 

[Guest]

Shouldn't you be saving that file as personal.xlsb

http://www.rondebruin.nl/personal.htm
(from Ron de Bruin's site)

Marcela wrote:

o hi again, forgot to say that i have both office 2003 & 7 due other
application that can run only as office 2003 , thank you

 

[Ron de Bruin]

Hi Marcela

all my macros created in xlsx file format are gone

That's correct
In this file format all macros will be deleted from your file
xlsm is the format with macros


I suggest this

Rename the Personal.xls with your code to myoldpersonal.xls

Creat a new Personal file (see my site)
Open myoldpersonal.xls

When you go to the VBA editor you see both workbooks now
Drag and drop the modules from myoldpersonal.xls to the new Persnoal file

 

[Dave Peterson]

I don't use xl2007 much, but this site:

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

says that xlsx is a file with no macros.

So that macros are gone doesn't seem like a surprise.

 

[Jim Rech]

FWIW, I have one Personal.xls that I use with Excel 2000, 2002, 2003 and
2007. It works fine and Excel 2007 never gives me a message like you're
getting.

--
Jim
|
|
| "Dave Peterson" wrote:
|
| > Shouldn't you be saving that file as personal.xlsb
| >
| > http://www.rondebruin.nl/personal.htm
| > (from Ron de Bruin's site)
| >
| > Marcela wrote: Hi Dave and thank you - so should i re save the personal
file? i still have some old macros that i use in that format personal.xls -
also this issie came up 2-3 weeks ago - i have been running Office 2007 for
the past 6 months on vista and never seen this error message. and which is
wierd as well - all my macros created in xlsx file format are gone.. all at
once 2-3 week ago, thank you
|
| > >
| > > 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 form a trusted source before opening the file. Do you want to
open the
| > > file now?? // will come up everytime new excel file is opened or xlsx
file
| > > type is open. recently reinstalled Office 2007 - it didn't fixed this
issue -
| > > any sugestions?
| >
| > --
| >
| > Dave Peterson
| >