import extracted text to excel

jeanmarie · Post by **jeanmarie** » Thu Jan 08, 2009 2:18 pm

how do I copy the extracted text with a tag macro of webrecorder to a excel cell?

Post by **Marcus Tettmar** » Thu Jan 08, 2009 3:45 pm

There are a number of ways you can output to Excel:

1. Setfocus and paste it (send CTRL-v)
2. Use DDERequest
3. Use VBScript
4. Write to a CSV file using WriteLn

There are sample macros which demonstrate items 2 and 3. Also read this:
http://www.mjtnet.com/blog/2007/07/02/m ... xcel-data/

jeanmarie · Post by **jeanmarie** » Fri Jan 09, 2009 12:42 pm

thank you for the tips

I am using on of the option to read excel... but the following command:

VBRun>OpenExcelFile,"C:\CEF\T_Isin.xls"

is not finding the T_Isin file on C:\CEF

Post by **Marcus Tettmar** » Fri Jan 09, 2009 12:44 pm

Remove the quotes. VBRun accepts Macro Scheduler string values. So you should not use quotes in VBRun.