Excel macro that uses Lotus 1-2-3 file?

**thedon_1** · 06-11-2008, 09:52 AM

I need to pull data from 200 Lotus 1-2-3 files and put them in an excel.
Is this even possible? How would i go about doing this?

Thanks

**dominicb** · 06-11-2008, 10:13 AM

Good afternoon thedon_1

The first thing to do is record the task you are doing with the macro recorder to see what kind of code it generates. If it's possible to do, this will show in the code. (Tools > Macro > Record New Macro).

Then post the code here and someone will help you out with tidying it up and looping through your 200 files.

HTH

DominicB

**thedon_1** · 06-12-2008, 10:22 AM

Ok so i recorded a macro. I simply copied and pasted 2 cells from my Lotus 1-2-3 spreadhseet into excel.

When i ran te macro, it didn't copy what it should have. Here is the code.

Sub test123()
'
' test123 Macro
' Macro recorded 12/06/2008 by GB009597
'

'
    Range("A3").Select
    ActiveSheet.Paste
    Range("A5").Select
    ActiveSheet.Paste
    Range("E12").Select
End Sub

It didn't seem to reference the Lotus 1-2-3 at all.
Is this not possible to do?