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

willlobb · Apr 4th, 2002, 04:59 AM

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 · Apr 4th, 2002, 07:29 AM

Does anyone know if this is possible?

Jay Petrulis · Apr 4th, 2002, 07:38 AM

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 · Apr 4th, 2002, 07:44 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 04:59 AM	#1
willlobb Board Regular Join Date: Mar 2002 Posts: 103	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 ]

Apr 4th, 2002, 07:29 AM	#2
willlobb Board Regular Join Date: Mar 2002 Posts: 103	Does anyone know if this is possible?

Apr 4th, 2002, 07:38 AM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	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

Apr 4th, 2002, 07:44 AM	#4
willlobb Board Regular Join Date: Mar 2002 Posts: 103	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