Hi,
I am developing an application with the following ..
VB6.0, MS-Office 97 and ADO2.6
I want to export some data based on query to excel.
I have created a query and a macro in ms-access. query1 will have to
parameters date1 and date2. Macro1 is defined as Action->OutputTo , object type
-> query, Object name-> query1 and output format ->Microsoft Excel (*.xls).
eg. query1 -> select * from employee where doj between date1 and date2
macro1 -> uses query1 and exports the output to excel.
Now my requirement is how can send date1 and date2 values from VB application
to query stored in database and how can i execute the macro from VB application.
Can anybody help me out....
Thanks in advance
regards,
Access_mk
---------------------------------
Yahoo! Photos Showcase holiday pictures in hardcover
Photo Books. You design it and well bind it!
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
