How do I automatically import CSV data on startup
 

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

--
gyro222
-----------------------------------------------------------------------
gyro2222's Profile: http://www.excelforum.com/member.php...fo&userid=1489
View this thread: http://www.excelforum.com/showthread.php?threadid=26527

How do I automatically import CSV data on startup
 

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. :-)



"gyro2222" wrote:


I am trying to import data from a txt file exported from another
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
Hal


--
gyro2222
------------------------------------------------------------------------
gyro2222's Profile: http://www.excelforum.com/member.php...o&userid=14895
View this thread: http://www.excelforum.com/showthread...hreadid=265274