Importing data

[schnett]

Hi,
I would like to write a macro to do the following :
1. Paste copied data into Excel from a non-microsoft program (dat
always is in the same format)
2. Format as delimited text.

I have been unable to do without generating an import text file which
don't want to do

 

[hgrove]

schnett wrote...

I would like to write a macro to do the following :
1. Paste copied data into Excel from a non-microsoft program
(data always is in the same format)
2. Format as delimited text.

I have been unable to do without generating an import text file
which I don't want to do.

It all depends on what the data from the other application looks like
Presumably you're copying something in that other application (if it'
a commercial app, it's best to let us know what it is; on the othe
hand, if it's an in-house system, it'd be helpful if you gave us
rough description of what you're copying), then using Paste Special
Text to paste into Excel? If you can paste the data into Excel as plai
text in a single column, it's always possible to parse it as needed
but you'd need to give us details about the original layout and th
desired final layout.

If you can't paste the data into Excel as plain text, then I doub
there's any way to do this without an intermediate text file. Do yo
have to use the other app to generate that text file