Using VBA to interact Excel spreadsheets with other non-Microsoft applications RRS feed

  • Question

  • Hi,

    I am using Excel 2003 as my company has not yet upgraded to a newer version.  I would like to be able to copy information from the spreadsheet and paste it into an IBM Personal Communication session or Windows command prompt.  Is there a way this can be done?  Every reference has to deal with Microsoft applications or web-based, nothing about other applications.

    Tuesday, May 8, 2012 7:30 PM

All replies

  • If the other applications support VBA (Microsoft has licensed VBA to a number of 3rd parties) then this is easy. In this case I suspect not, so you can only copy data to the clipboard or use the very risky SendKeys command. SendKeys is risky because it's impossible to predict what different users might do, so a sample worst case is that keys that simply enter information in one app disastrously changes info in another.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Tuesday, May 8, 2012 9:47 PM