Is there an alternative to Sendkeys for the Mac? - REALLY NE

[willlobb]

On a PC you can use the SendKeys function, is there an alternative to this for applemac? I need to switch from one workbook to another (by using the Alt+Tab keys) is there any way to do this on a mac?
This message was edited by willlobb on 2002-04-04 04:08

 

[willlobb]

Does anyone know if this is possible?

 

[Jay Petrulis]

Do you know the names of the open workbooks?

Thisworkbook.Activate
Workbook("name.xls").Activate

should do what you want rather than using SendKeys.

Regards,
Jay

 

[willlobb]

The name depends on the value of a cell. It opens OK. eg, it opens "Transactions For Week " & Range("Week1Date"), but then i need it to switch between that workbook and another one that is open. Also, i have an email macro, and it uses the shortcut key Alt+S (send in outlook express)to send the emails, how would i be able to do this? Is it possible?
Thanks
Will