Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Initiate MSQUERY via VBA
Message
From
07/11/2005 12:54:07
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01065797
Message ID:
01066083
Views:
12
Sergey, Thanks a lot !
The best way till now to solve the problem.

[ ]'s
Peter

>>Thanks for the help Sergey, but what I really need is to show the MSQuery Form so the user can build its own query and return this Select statement to excel.
>
>You can use WSH to send keystrokes to Excel to invoke Edit Query dialog
oShell = Createobject("wscript.shell")
>oShell.AppActivate(oExcel.Caption)
>oShell.SendKeys("%DDE")
>
Previous
Reply
Map
View

Click here to load this message in the networking platform