Add-ins for Excel 2007

M

mike_vr

Hi all,

Quick question, does anybody know if there is a Flat File Exporter or
something equivalent available for Excel 2007?

Thanks,

Mike
 
M

mike_vr

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
 
D

Dave F

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?
 
J

Jim Rech

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
|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
 
M

mike_vr

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
 
M

mike_vr

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
 
J

Jon Peltier

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
 
M

mike_vr

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
 
M

mike_vr

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
 
J

Jon Peltier

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

- Jon
 
Top