Macro - Application.Sendkeys, New Laptop Problem
-
Hi ALL! I wrote a very small app which reads out the cell values in excel and "Sendkey"s them to another application. I would firstly Send an 'alt tab' to set focus on the receiving application. Then basically flush all of the cell values. E.g. of code used: Application.Sendkeys "%{tab}", True Application.Sendkeys ActiveCell.Value, True Now, the problem is that it used to work perfectly on my old slow ass donkey machine. I recently got a newer, slicker machine and it just doesnt write the values to the application. It 'alt tabs' but just doesnt write them. Any suggestions? I will consider looking into AppActivate instead of 'alt tab'. Thanks Peeps!
-
Hi ALL! I wrote a very small app which reads out the cell values in excel and "Sendkey"s them to another application. I would firstly Send an 'alt tab' to set focus on the receiving application. Then basically flush all of the cell values. E.g. of code used: Application.Sendkeys "%{tab}", True Application.Sendkeys ActiveCell.Value, True Now, the problem is that it used to work perfectly on my old slow ass donkey machine. I recently got a newer, slicker machine and it just doesnt write the values to the application. It 'alt tabs' but just doesnt write them. Any suggestions? I will consider looking into AppActivate instead of 'alt tab'. Thanks Peeps!
I have discovered that Excel 2003 likes to choose when to send the alt key (%). If I edit the code and save it, then run it. it works fine. If I open the xls file and just run it, it does not work. Please can anyone tell me how to get excel to send the alt key every time? I have tried "Application.Sendkeys" and "Sendkeys". Thank You