Error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 said:
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
Click to expand...
 
Hi Marcela
all my macros created in xlsx file format are gone
Click to expand...
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
 
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
| >
 
Back
Top