Opening .RPT files in 2007 utilizing the Wizzard

[Bereford]

I just purchased a new computer with Windows 7 Pro OS. I also upgraded my Office Professional to 2007 (from 2003). I'm having trouble finding/opening a .RPT file attachment to my Eudora email program and opening it up in Excel using the Wizzard. Because of the comma delimited nature of the weekly inventory reports I receive, I have normally in the past used the Wizzard to control which information goes into which cell. Windows 7 asks me which program I would like to use to open this .rpt file but doesn't recognize the file extension, or if it does, will not take me to the Wizzard automatically. The result is that all of the information goes into one cell as opposed to being able to populate many columns. Right now the stoneage doesn't look so bad!

 

[Andrew Poulsom]

If you save the file and open it in Excel you should get the Wizard. Or you could use Data|Text To Columns after you open it.