Hello everyone,
I am new at this forum so please be easy on me.
I have the following problem.
I have written an app in visual basic which connects to Excel and reacts when user double click on the cell.
All is fine when UAC is turned off. However when UAC is not turned off then OLE action is not completed unless user clicks somewhere on the spreadsheet.
In my code I've tried to use moExcelApp.SendKeys "{ESC}" but it does not work.
The cursor still flashes in the cell which was double clicked.
But when I click anywhere on the spreadsheet OLE completes fine.
I appreciate any help.
Thanks,
jas
Bookmarks