| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003, Vista, and Sendkeys
Greetings. I just reformatted one of my PCs, installed Windows Vista and
then Excel 2003 so that I had a clean installation. I found that Sendkeys does not work on Excel 2003 on Windows Vista. I recognize that Sendkeys should only be used when all else fails, but there are those situations. The solution is to do the following: (in this case for File, Open) Dim wshShell Set wshShell = CreateObject("WScript.Shell") wshShell.SendKeys "%FO", True Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing Violation when using Excel 2003 on Vista | Excel Discussion (Misc queries) | |||
| Excel 2003 on Windows Vista | Excel Discussion (Misc queries) | |||
| Excel 2003 Running in Vista | Excel Discussion (Misc queries) | |||
| Excel 2003 Vista fax/print problems | Excel Discussion (Misc queries) | |||
| What are the difference between 2000, 2003 and Vista for Excel Use | New Users to Excel | |||
Threaded Mode
