You could have browsed to the 2007 library and selected the file; it would
have then shown up in the list.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"mike_vr" wrote in message
...
Hi all,

Thanks for your help, problem solved!! Basically went into the Library in
Excel 97 program files and copied the add-in and pasted into the Library
in
2007. Not sure if it's entirely legit or the right way of doing it but
works
perfectly now.

Thanks again,

Mike
"mike_vr" wrote:

Thanks Jon

Been down that route before, but the option to check "flat file exporter"
isn't there, which is where my original confusion originated. Could it be
something available only to Excel 97, or perhaps even something someone
in
our office created years ago and not actually an Excel Add-in?!?

Thanks,

Mike
"Jon Peltier" wrote:

Apparently the "Flat File Exported" add-in is not installed.

Try this sequence:

Office button menu Excel Options button.
Add-ins item in the left column.
Bottom: Manage Excel Add-ins Go button.
Finally the familiar Add-Ins dialog.

Five mouse operations, compared to two in prior Excel versions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"mike_vr" wrote in message
...
Morning Dave / Jim,

If you're still out there to help, here is the code:

Sub AutoJournal()

Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.StatusBar = "Exporting AutoJournal..."
Range("C3,I3").Select
Selection.ClearContents
Range("A36:G63").Select
Selection.Copy
Range("A1").Select
Sheets("AUTOJOURNAL").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlValues

'That's all fine but then this is where we get a run-time error 9:
subscript
out of range

AddIns("Flat File Exporter").Installed = False
On Error Resume Next
AddIns("Flat File Exporter").Installed = True

Dim autoPath As DataObject
Set autoPath = New DataObject
autoPath.SetText "J:\FTP\AUTOACRS.DAT"
autoPath.PutInClipboard
Application.StatusBar = False

End Sub

Does this make sense to you, 'cos it's fairly Greek to me.

Thanks for the help,

Mike

"Dave F" wrote:

Well posting the code would probably help us understand what you're
doing.
But what happens when you try to run the macro in XL 2007? Do you
get
errors? If so, what are the errors?
--
Brevity is the soul of wit.


"mike_vr" wrote:

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