Refresh external data through macro in office 97

Posted by Jerry on December 13, 2001 11:10 AM

: I created a macro to read in and refresh an external data source (flat file, comma delimited). This runs fine in Excel 2000, but when I go to run it at the user's computer (office 97), it errors out at the following line:

Posted by Dan on December 13, 2001 11:17 AM

What's the error?

Posted by Mark W. on December 13, 2001 11:50 AM

Jerry, if you're using Excel 2000's
Data | Get External Data | Import Text File...
menu command its refresh is not supported by
Excel 97.

Posted by Jerry on December 13, 2001 12:00 PM

Using VBA you could do:

Dim i as Integer

For i = 25 To 1 Step -1
ActiveSheet.Rows(i).EntireRow.Insert
Next i

Posted by Jerry Lucas on December 13, 2001 12:03 PM

It is error 1004, incomplete data source.

Is there not a work around to import the flat file into excel 97.

thanks

Posted by Mark W. on December 13, 2001 12:11 PM

> Is there not a work around...

You'd have to use Text to Columns...