LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to get data from one application into excel whatzzup Excel Discussion (Misc queries) 1 April 29th 08 04:56 PM
Macro to paste and print in another application punter Excel Discussion (Misc queries) 1 June 17th 06 04:40 PM
Paste to Another Application Dennis Excel Worksheet Functions 0 May 5th 06 04:28 AM
Cut and paste from Excel to AS/400 application Joe Cali Excel Discussion (Misc queries) 0 March 29th 06 11:36 PM
macro to close excel application other than application.quit mary Excel Programming 1 September 14th 04 03:43 PM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"