How to fill a sheet in Excel2003 with CSV data?

[tmarko]

I use server-side calculations in an OWC(Office spreadsheet component)
send the resulting data as string (formatted as CSV) to my Client. Ho
can I fast fill an Excelsheet(2003) with this data passed as string
Must I loop through the CSV data? When saved as file (.csv) on th
server I can open the .CSV manually on the client fast like opening a
ordinary .xla file. But how do I do it programmatically when the cs
data is in a string on my VBA client? Cannot find the correc
propertie

 

[David McRitchie]

If you paste it into Excel you can use Text to Columns
same as the wizard.

For programming you can use Chip Pearson's
Importing Text Files
http://www.cpearson.com/excel/imptext.htm

 

[tmarko]

Hi David McRitchie: Thanks for your reply!

After looking at Chip Pearson's interesting webpage, if I understan
correct, I need to work with a file before being able to use his code
I need to save the CSV data as a .CSV file. When working with a file
need to involve the filestructure. I was hoping to avoid that. As
wrote in my question I pass the data frpm server to Client as a strin
parameter with CSV data. I can see the data on my Client, but canno
find an easy and fast way to populate an open Exel sheet.

Thanks anyway for the help so fa

 

[David McRitchie]

Sorry, guess I messed this up by answering, looks like
many of the questions for OWC which I know nothing about,
are posted to microsoft.public.office.developer.web.components
which I guess would be the most appropropriate group and I don't
recognize the posters/respondes names for what was returned when I did
Google Groups search.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Jon Peltier]

I think David's suggestion still could do it. What's the data look like
if you paste the incoming stream into a worksheet? If you get a column
of cells that contain CSV data (with carriage returns in the feed
pushing output to the next cell down), then text to columns should be
able to split it up for you.

- Jon