Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Ralph,
Not sure if anything like this can be done! We work with a propriatary software product builds an SQL statement with the data that we key in. if you do not have a chance to write the sql-statement yourself then you could try to punch the data in with "sendkeys" in VBA. Have a look at VBA-Help on this. However, if you want to do this, you have to know how to call the programms for sql with VBA. If you know that you may find a way to directly create the sql-statement and fire the execution. So, first try to find out what possibilities your software offers by reading the manual or contacting support etc. arno |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to get data from one application into excel | Excel Discussion (Misc queries) | |||
Macro to paste and print in another application | Excel Discussion (Misc queries) | |||
Paste to Another Application | Excel Worksheet Functions | |||
Cut and paste from Excel to AS/400 application | Excel Discussion (Misc queries) | |||
macro to close excel application other than application.quit | Excel Programming |