load .csv file into Sheet 2?

H

hmmm...

I am building a charting application using Excel 97.
Worksheet1 contains a lot of values and formulas and
contains the chart.

Is there a way to load a .csv file into work sheet 2 after
an .xls file has been opened into work sheet 1?
 
D

Dave Peterson

In xl2k and above, there's an option under Data|Import external data (xl2002
wording).

but in xl97, you can open the file in worksheet in another workbook and then
just copy|paste it to its final destination (or just move the worksheet??).

(In fact, that's still the way I do it in xl2002. Old dogs/new tricks???)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top