Morning Jim,

Thanks for your response. I've given a slightly more detailed description of
the problem in my response to Dave, including where the error occurs, does
this make any sense to you?

Also, tried the Add-ins tab but to no luck, and can't find it anywhere
within Microsoft online or the web, so not sure if it even exists anymore?!?

Thanks,

Mike

"Jim Rech" wrote:

What happens when you try this "Flat File Exporter" in Excel 2007? If you
cannot find the menu item that it (presumably) used to add to the Tools or
Data or File menu, look at the Add-Ins tab.

--
Jim
"mike_vr" wrote in message
...
|I don't think so, but this could be out of my league. Basically we were
using
| a macro to convert the Excel 97 file to a .dat file, which is then stored
on
| one of our drives before being exported to our accounting package. All
this
| was created before my time though, so I have limited knowledge on how to
| update this to tie in to Excel 2007.
|
| Does it sound like there is an answer to this, and would it help if you
saw
| the original macro code?
|
| Thanks,
|
| Mike
|
| "Dave F" wrote:
|
| Can't you just save the document as a .csv file?
|
| Dave
| --
| Brevity is the soul of wit.
|
|
| "mike_vr" wrote:
|
| Hi all,
|
| Quick question, does anybody know if there is a Flat File Exporter or
| something equivalent available for Excel 2007?
|
| Thanks,
|
| Mike