View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default 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