Error message
 

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?

Error message
 

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

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

Marcela wrote:

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

Error message
 

"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

Error message
 

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


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

Error message
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Marcela" wrote in message ...


"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

Error message
 

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

http://technet2.microsoft.com/Office....mspx?mfr=true

says that xlsx is a file with no macros.

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

Marcela wrote:

"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


--

Dave Peterson

Error message
 

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
"Marcela" wrote in message
...
|
|
| "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
|