View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bl bl is offline
external usenet poster
 
Posts: 7
Default Copy Data to non-office program

Dear all,

I need to copy an Excel spreadsheet data about 50 rows and 6 columns to an
non-office program which is in some type of form. Right now, we are use a
small Macro program to remember the keystroke to copy the data, flip between
the programs and paste the data.

I am wondering whether I can do that through VBA. Can I store all the data
in an array and switch to the program and copy the information? How can I
call the other application and continue the VBA?

Thank you.

Regards,

BL