How do I automatically import CSV data on startup

[gyro2222]

I am trying to import data from a txt file exported from anothe
program. It is always the same name (export.csv).

I would like this data to be imported into my spreadsheet (report.xls
automatically on startup.
Suggestions, ps.
Regards
Ha

 

[Guest]

From a New Excel SpreadSheet
Data -> Import External Data -> Import Data
From Select Data Source
Files of Type = Text Files -> File Name = export.csv
From Text Import Wizard
Next (to step 2) -> Delimiters = comma -> Next (to step 3) -> Finish
From Import Data
Specifiy import location of data -> OK
From Spreadsheet
Data -> Import External Data -> External Data Range Properties
From External Data Range Properties
Under "Refresh Control", select the check box beside "Refresh Data on File
Open" -> OK

-OR-

You could just open the csv file.