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