Macro to cut and paste from Excel to another application
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
|