Updating worksheet data

Posted by MBR on January 25, 2002 11:37 AM

Hello all...

We have a worksheet that was created by using the "Get External Data", from a text file. We would like to have this worksheet update from the text file each time Excel is opened because the text file changes daily. What would be the best mechanism to do this? A Macro? We are UNIX geeks so we are in strange territory on this one.

Thanks!

Posted by Carl B on January 25, 2002 9:36 PM

In VB
Private Sub Workbook_Open()
(your code here)
End Sub