Hi,
I have progam that should send result of two select statement to text files and then run macro in Excel that parse those text files and populate cells.
Code have only 2 lines:
Select field1,field2 from table1 to file Text1.txt
Select field1,field2 from table2 to file Text2.txt
Questions:
1. To execute second select statement I have to keep pressing any key to go to the end of result set.Is there any way to avoid this(I tryed Go Bottom but doesn't help)so I have program that populate those text files without any user interaction?
2.If I want to open Excel file where I have macro that parse text from those text files I tryed adding thost lines I read in another posting:
oX=CreateObject("Excel.Application"
oX.Workbooks.Open("C:\Book1.xls"
but it doesn't do anything nor I have any message?
Any help appreciated
Lyn
I have progam that should send result of two select statement to text files and then run macro in Excel that parse those text files and populate cells.
Code have only 2 lines:
Select field1,field2 from table1 to file Text1.txt
Select field1,field2 from table2 to file Text2.txt
Questions:
1. To execute second select statement I have to keep pressing any key to go to the end of result set.Is there any way to avoid this(I tryed Go Bottom but doesn't help)so I have program that populate those text files without any user interaction?
2.If I want to open Excel file where I have macro that parse text from those text files I tryed adding thost lines I read in another posting:
oX=CreateObject("Excel.Application"
oX.Workbooks.Open("C:\Book1.xls"
but it doesn't do anything nor I have any message?
Any help appreciated
Lyn