I have read almost all the posts about personal.xls either here or some
other Excel tips website. but couldn't find one solution for my situation.
this one is close to my problem, but my problem is even worse than that.
(http://www.pcreview.co.uk/forums/thread-3183383.php)

I upgraded office to 2007 at the end of last December. Before upgrading, i
saved the personal.xls in a disk. after upgrading, i was going to load the
macros in this file to a new macro workbook.

i double clicked my dear "personal.xls", got a 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?". then i chose "yes". then go to developer, click macro, chose
"myoldPersonal.xls", got empty content. where is my macro?? ?I click Edit,
another message, " can't edit hidden workbook, unhide workbook by using
unhide command".

ok, then i unhide it. go to macro, still empty. close it. open it again,
same message, "the file you are trying to open........", click yes, go to
developer, chose macro, chose this personal.xls file, empty content!! click
edit, this time no more message, but vba window shows no modules in there...

where are my macros?? the size of personal.xls is big, seems my macros still
there. but i can't get them shown up.

i searched lots of posts, couldn't find a solution. i gave up. please help
me!!

thank you so much!!

PS, i learned a lot when i read the posts. Dave Peterson, Ron Bruin, many
other experts...thank you...

Regards,
Lin

I don't have a real good guess why you're getting the error.

But I would suggest that you try opening your personal.xls in the old version of
excel -- if you have it or know someone who does.

Or even finding another copy and trying to open that in xl2007.

Lin wrote:

I have read almost all the posts about personal.xls either here or some
other Excel tips website. but couldn't find one solution for my situation.
this one is close to my problem, but my problem is even worse than that.
(http://www.pcreview.co.uk/forums/thread-3183383.php)

I upgraded office to 2007 at the end of last December. Before upgrading, i
saved the personal.xls in a disk. after upgrading, i was going to load the
macros in this file to a new macro workbook.

i double clicked my dear "personal.xls", got a 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?". then i chose "yes". then go to developer, click macro, chose
"myoldPersonal.xls", got empty content. where is my macro?? ?I click Edit,
another message, " can't edit hidden workbook, unhide workbook by using
unhide command".

ok, then i unhide it. go to macro, still empty. close it. open it again,
same message, "the file you are trying to open........", click yes, go to
developer, chose macro, chose this personal.xls file, empty content!! click
edit, this time no more message, but vba window shows no modules in there...

where are my macros?? the size of personal.xls is big, seems my macros still
there. but i can't get them shown up.

i searched lots of posts, couldn't find a solution. i gave up. please help
me!!

thank you so much!!

PS, i learned a lot when i read the posts. Dave Peterson, Ron Bruin, many
other experts...thank you...

Regards,
Lin

--

Dave Peterson

I have both office 2003 and 2007 installed at home, i will try to open it
there to see.

Thank you!



"Dave Peterson" wrote:

I don't have a real good guess why you're getting the error.

But I would suggest that you try opening your personal.xls in the old version of
excel -- if you have it or know someone who does.

Or even finding another copy and trying to open that in xl2007.

Lin wrote:

I have read almost all the posts about personal.xls either here or some
other Excel tips website. but couldn't find one solution for my situation.
this one is close to my problem, but my problem is even worse than that.
(http://www.pcreview.co.uk/forums/thread-3183383.php)

I upgraded office to 2007 at the end of last December. Before upgrading, i
saved the personal.xls in a disk. after upgrading, i was going to load the
macros in this file to a new macro workbook.

i double clicked my dear "personal.xls", got a 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?". then i chose "yes". then go to developer, click macro, chose
"myoldPersonal.xls", got empty content. where is my macro?? ?I click Edit,
another message, " can't edit hidden workbook, unhide workbook by using
unhide command".

ok, then i unhide it. go to macro, still empty. close it. open it again,
same message, "the file you are trying to open........", click yes, go to
developer, chose macro, chose this personal.xls file, empty content!! click
edit, this time no more message, but vba window shows no modules in there...

where are my macros?? the size of personal.xls is big, seems my macros still
there. but i can't get them shown up.

i searched lots of posts, couldn't find a solution. i gave up. please help
me!!

thank you so much!!

PS, i learned a lot when i read the posts. Dave Peterson, Ron Bruin, many
other experts...thank you...

Regards,
Lin

--

Dave Peterson
.