M
m96
hi,
most of the time i get the csv file inlined into my mail instead of
attached.
so i would like to copy and paste/import the csv data into excel, instead of
* opening a text editor
* pasting from clipboard
* saving as .csv file
* opening it with excel
i investigated the import function
ActiveSheet.QueryTables.Add(Connection:="text;<filename")
where the connection argument does not accept 'clipboard'
and paste special function
ActiveSheet.PasteSpecial Format:="text"
where the format argument does not accept 'csv'.
do you have any ideas - beside parsing the whole csv for my-self - how
to automated structured copy & paste of csv data from clipboard to excel?
i would appreciate any ideas.
thank in advance.
most of the time i get the csv file inlined into my mail instead of
attached.
so i would like to copy and paste/import the csv data into excel, instead of
* opening a text editor
* pasting from clipboard
* saving as .csv file
* opening it with excel
i investigated the import function
ActiveSheet.QueryTables.Add(Connection:="text;<filename")
where the connection argument does not accept 'clipboard'
and paste special function
ActiveSheet.PasteSpecial Format:="text"
where the format argument does not accept 'csv'.
do you have any ideas - beside parsing the whole csv for my-self - how
to automated structured copy & paste of csv data from clipboard to excel?
i would appreciate any ideas.
thank in advance.